Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table containing the standards referenced in the database
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
std_id |
serial |
|
nextval('tr_standard_std_std_id_seq'::regclass) |
Automatic numeric identifier of the standard |
|||
|
|
std_name |
varchar(50) |
|
|
|
Common name of the standard |
|
|
|
std_date |
date |
|
|
|
|
Date of publication of the standard |
|
|
std_url |
varchar(255) |
|
|
|
|
Url for accessing the standard document |
|
|
std_version |
varchar(10) |
|
|
|
Standard version information |
Foreign Keys
There are no foreign keys for table tr_standard_std
Check Constraints
There are no check constraints for table tr_standard_std
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
std_name, std_version |
|
The name / version pair of a standard must be unique |
||
btree |
|
std_id |
|
Triggers
There are no triggers for table tr_standard_std
Rules
There are no rules for table tr_standard_std
Policies
There are no policies for table tr_standard_std
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
macq_std_id |
std_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 unit |
||||
mdet_std_id |
std_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 standard |
||||
mobj_std_id |
std_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 unit |
||||
mzon_std_id |
std_id |
No Action |
No Action |
|
Immediate |
a measure can be attached to O or 1 standard |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tr_standard_std (
std_id SERIAL,
std_name VARCHAR(50) NOT NULL,
std_date DATE,
std_url VARCHAR(255),
std_version VARCHAR(10) NOT NULL,
CONSTRAINT c_uni_name_version_std UNIQUE(std_name, std_version),
CONSTRAINT tr_standard_std_pkey PRIMARY KEY(std_id)
) ;
COMMENT ON TABLE public.tr_standard_std
IS 'Table containing the standards referenced in the database';
COMMENT ON COLUMN public.tr_standard_std.std_id
IS 'Automatic numeric identifier of the standard';
COMMENT ON COLUMN public.tr_standard_std.std_name
IS 'Common name of the standard';
COMMENT ON COLUMN public.tr_standard_std.std_date
IS 'Date of publication of the standard';
COMMENT ON COLUMN public.tr_standard_std.std_url
IS 'Url for accessing the standard document';
COMMENT ON COLUMN public.tr_standard_std.std_version
IS 'Standard version information';
COMMENT ON CONSTRAINT c_uni_name_version_std ON public.tr_standard_std
IS 'The name / version pair of a standard must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |