Schema
Owner
woodseer
Tablespace
(default)
Descriptions
Table of projects
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
proj_id |
serial |
|
nextval('t_project_proj_proj_id_seq'::regclass) |
Digital automatic identifier of the project |
|||
|
|
proj_code |
varchar(16) |
|
|
Unique code to identify the project |
||
|
|
proj_label |
varchar(128) |
|
|
|
Label of the project |
|
|
|
proj_description |
varchar(255) |
|
|
|
|
description of the project |
|
|
proj_url |
varchar(255) |
|
|
|
|
url of the project |
|
|
proj_start_date |
date |
|
|
|
Start date of the project |
|
|
|
proj_end_date |
date |
|
|
|
|
End date of the project |
Foreign Keys
There are no foreign keys for table t_project_proj
Check Constraints
There are no check constraints for table t_project_proj
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
btree |
|
proj_code |
|
The code of a project must be unique |
||
btree |
|
proj_id |
|
Triggers
There are no triggers for table t_project_proj
Rules
There are no rules for table t_project_proj
Policies
There are no policies for table t_project_proj
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|---|---|
obj_proj_id |
proj_id |
No Action |
No Action |
|
Immediate |
An object is link to 1 and only 1 project |
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
1 |
Pages |
1 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.t_project_proj (
proj_id SERIAL,
proj_code VARCHAR(16) NOT NULL,
proj_label VARCHAR(128) NOT NULL,
proj_description VARCHAR(255),
proj_url VARCHAR(255),
proj_start_date DATE NOT NULL,
proj_end_date DATE,
CONSTRAINT c_uni_code_proj UNIQUE(proj_code),
CONSTRAINT t_projet_proj_pkey PRIMARY KEY(proj_id)
) ;
COMMENT ON TABLE public.t_project_proj
IS 'Table of projects';
COMMENT ON COLUMN public.t_project_proj.proj_id
IS 'Digital automatic identifier of the project';
COMMENT ON COLUMN public.t_project_proj.proj_code
IS 'Unique code to identify the project';
COMMENT ON COLUMN public.t_project_proj.proj_label
IS 'Label of the project';
COMMENT ON COLUMN public.t_project_proj.proj_description
IS 'description of the project';
COMMENT ON COLUMN public.t_project_proj.proj_url
IS 'url of the project';
COMMENT ON COLUMN public.t_project_proj.proj_start_date
IS 'Start date of the project';
COMMENT ON COLUMN public.t_project_proj.proj_end_date
IS 'End date of the project';
COMMENT ON CONSTRAINT c_uni_code_proj ON public.t_project_proj
IS 'The code of a project must be unique';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |