db_globoxylo |
|
Table: tr_file_fil
db_globoxylo |
|
Table: tr_file_fil
Schema
Owner
globoxylo
Tablespace
(default)
Descriptions
Table of measurement files
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
fil_id |
serial |
|
|
|
nextval('tr_file_fil_fil_id_seq'::regclass) |
Digital automatic file identifier |
|
|
fil_name |
varchar(120) |
|
|
|
|
File name |
|
|
fil_url |
varchar(255) |
|
|
|
|
url to access the file |
Foreign Keys
There are no foreign keys for table tr_file_fil
Check Constraints
There are no check constraints for table tr_file_fil
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
btree |
|
fil_name, fil_url |
|
|
The name / url pair of a file must be unique |
|
btree |
|
fil_id |
|
|
|
Triggers
There are no triggers for table tr_file_fil
Rules
There are no rules for table tr_file_fil
Policies
There are no policies for table tr_file_fil
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
grp_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a grouping can be attached to O or 1 file |
||||
msam_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 file |
||||
mtre_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 file |
||||
mzon_fil_id |
fil_id |
No Action |
No Action |
|
Immediate |
a measurement can be attached to O or 1 file |
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
-1 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
fil_id SERIAL,
fil_name VARCHAR(120) NOT NULL,
fil_url VARCHAR(255) NOT NULL,
CONSTRAINT c_uni_name_url_fil UNIQUE(fil_name, fil_url),
CONSTRAINT tr_file_fil_pkey PRIMARY KEY(fil_id)
) ;
COMMENT ON TABLE public.tr_file_fil
IS 'Table of measurement files';
COMMENT ON COLUMN public.tr_file_fil.fil_id
IS 'Digital automatic file identifier';
COMMENT ON COLUMN public.tr_file_fil.fil_name
IS 'File name';
COMMENT ON COLUMN public.tr_file_fil.fil_url
IS 'url to access the file';
COMMENT ON CONSTRAINT c_uni_name_url_fil ON public.tr_file_fil
IS 'The name / url pair of a file must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|