Table tr_operator

pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr

Table: tr_operator_ope

Schema

public

Owner

woodseer

Tablespace

(default)

Descriptions

Operator table

Fields

Name	Data type	Default	Description
ope_id	serial	nextval('tr_operator_ope_ope_id_seq'::regclass)	Automatic digital operator identifier
ope_name	varchar(50)		Operator name
ope_first_name	varchar(50)		Operator's first name
ope_mail	varchar(120)		Operator email address
ope_employer	varchar(64)		Employer of Operator

Foreign Keys

There are no foreign keys for table tr_operator_ope

Check Constraints

There are no check constraints for table tr_operator_ope

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
c_uni_name_first_name_ope	btree		ope_name, ope_first_name			The name / first name pair of an operator must be unique
tr_operator_ope_pkey	btree		ope_id

Triggers

There are no triggers for table tr_operator_ope

Rules

There are no rules for table tr_operator_ope

Policies

There are no policies for table tr_operator_ope

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time	Description
tj_rol_ope_macq_romacq	public	c_fk_ope_romacq	romacq_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The rom_ope_id field necessarily corresponds to an existing operator
tj_rol_ope_mdet_romdet	public	c_fk_ope_romdet	romdet_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The rom_ope_id field necessarily corresponds to an existing operator
tj_rol_ope_mobj_romobj	public	c_fk_ope_romobj	romobj_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The rom_ope_id field necessarily corresponds to an existing operator
tj_rol_ope_mzon_romzon	public	c_fk_ope_romzon	romzon_ope_id	public.tr_operator_ope	ope_id	No Action	No Action	Immediate	The rom_ope_id field necessarily corresponds to an existing operator

Properties

Property	Value
Inherited From
Rows	0
Pages	0
System
Temporary
With OID

Definition

CREATE TABLE public.tr_operator_ope ( ope_id SERIAL, ope_name VARCHAR(50) NOT NULL, ope_first_name VARCHAR(50) NOT NULL, ope_mail VARCHAR(120), ope_employer VARCHAR(64), CONSTRAINT c_uni_name_first_name_ope UNIQUE(ope_name, ope_first_name), CONSTRAINT tr_operator_ope_pkey PRIMARY KEY(ope_id) ) ; COMMENT ON TABLE public.tr_operator_ope IS 'Operator table'; COMMENT ON COLUMN public.tr_operator_ope.ope_id IS 'Automatic digital operator identifier'; COMMENT ON COLUMN public.tr_operator_ope.ope_name IS 'Operator name'; COMMENT ON COLUMN public.tr_operator_ope.ope_first_name IS 'Operator''s first name'; COMMENT ON COLUMN public.tr_operator_ope.ope_mail IS 'Operator email address'; COMMENT ON COLUMN public.tr_operator_ope.ope_employer IS 'Employer of Operator'; COMMENT ON CONSTRAINT c_uni_name_first_name_ope ON public.tr_operator_ope IS 'The name / first name pair of an operator must be unique';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23