Table tr_file

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

Table: tr_file_fil

Schema

public

Owner

woodseer

Tablespace

(default)

Descriptions

Table of files of data and information

Fields

Name	Data type	Default	Description
fil_id	serial	nextval('tr_file_fil_fil_id_seq'::regclass)	Automatic numeric identifier of the file
fil_typf_id	integer		automatic numeric identifier of the type of file
fil_name	varchar(32)		File name
fil_description	varchar(255)		Description of the file
fil_url	varchar(255)		link to the file

Foreign Keys

Name	Fields	FK Table	FK Fields	Delete Action	Update Action	Deferrable	Check Time	Description
c_fk_typf_fil	fil_typf_id	public.tr_type_file_typf	typf_id	No Action	No Action		Immediate	The file must correspond to a file type

Check Constraints

There are no check constraints for table tr_file_fil

Indices

Name	Type	Fields	Description
c_uni_name_url_fil	btree	fil_name, fil_url	The name / url pair of a file must be unique
tr_file_fil_pkey	btree	fil_id
x_btr_fkey_typf_file	btree	fil_typf_id	Foreign key index to speed up updates / deletion

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	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time	Description
t_acquisition_acq	public	c_fk_fil_acq	acq_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	an acquisition must be associated to one source file
t_detection_singularity_det	public	c_fk_fil_det	det_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a singularity detection is associated to one and only one source file
t_measure_macq	public	c_fk_fil_macq	macq_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measure can be attached to O or 1 file
t_measure_mdet	public	c_fk_fil_mdet	mdet_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measure can be attached to O or 1 file
t_measure_mobj	public	c_fk_fil_mobj	mobj_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measure can be attached to O or 1 file
t_measure_mzon	public	c_fk_fil_mzon	mzon_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate	a measurement can be attached to O or 1 file
tr_protocol_prot	public	c_fk_fil_prot	prot_fil_id	public.tr_file_fil	fil_id	No Action	No Action	Immediate

Properties

Property	Value
Inherited From
Rows	81
Pages	2
System
Temporary
With OID

Definition

CREATE TABLE public.tr_file_fil ( fil_id SERIAL, fil_typf_id INTEGER NOT NULL, fil_name VARCHAR(32) NOT NULL, fil_description VARCHAR(255), fil_url VARCHAR(255), CONSTRAINT c_uni_name_url_fil UNIQUE(fil_name, fil_url), CONSTRAINT tr_file_fil_pkey PRIMARY KEY(fil_id), CONSTRAINT c_fk_typf_fil FOREIGN KEY (fil_typf_id) REFERENCES public.tr_type_file_typf(typf_id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE ) ; COMMENT ON TABLE public.tr_file_fil IS 'Table of files of data and information'; COMMENT ON COLUMN public.tr_file_fil.fil_id IS 'Automatic numeric identifier of the file'; COMMENT ON COLUMN public.tr_file_fil.fil_typf_id IS 'automatic numeric identifier of the type of file'; COMMENT ON COLUMN public.tr_file_fil.fil_name IS 'File name'; COMMENT ON COLUMN public.tr_file_fil.fil_description IS 'Description of the file'; COMMENT ON COLUMN public.tr_file_fil.fil_url IS 'link to the file'; COMMENT ON CONSTRAINT c_fk_typf_fil ON public.tr_file_fil IS 'The file must correspond to a file type'; COMMENT ON CONSTRAINT c_uni_name_url_fil ON public.tr_file_fil IS 'The name / url pair of a file must be unique'; CREATE INDEX x_btr_fkey_typf_file ON public.tr_file_fil USING btree (fil_typf_id); COMMENT ON INDEX public.x_btr_fkey_typf_file IS 'Foreign key index to speed up updates / deletion';

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