SchemaSpy Analysis of istsos.demo - Columns | Generated by SchemaSpy |
Generated on Mon Jul 13 17:15 CEST 2015 |
| ||||||
|
istsos.demo contains 73 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
cron_log | datetime_clo | timestamptz | 35,6 | ||||
cron_log | details_clo | varchar | 2147483647 | √ | null | ||
cron_log | element_clo | varchar | 2147483647 | ||||
cron_log | id_clo | serial | 10 | √ | nextval('demo.cron_log_id_clo_seq'::regclass) | ||
cron_log | id_prc_fk | int4 | 10 | ||||
cron_log | message_clo | varchar | 2147483647 | ||||
cron_log | process_clo | varchar | 2147483647 | ||||
cron_log | status_clo | status | 2147483647 | √ | null | ||
event_time | id_eti | bigserial | 19 | √ | nextval('demo.event_time_id_eti_seq'::regclass) | ||
event_time | id_prc_fk | int4 | 10 | ||||
event_time | time_eti | timestamptz | 35,6 | ||||
feature_type | id_fty | serial | 10 | √ | nextval('demo.feature_type_id_fty_seq'::regclass) | ||
feature_type | name_fty | varchar | 25 | ||||
foi | desc_foi | text | 2147483647 | √ | null | ||
foi | geom_foi | geometry | 2147483647 | √ | null | ||
foi | id_foi | serial | 10 | √ | nextval('demo.foi_id_foi_seq'::regclass) | ||
foi | id_fty_fk | int4 | 10 | ||||
foi | name_foi | varchar | 25 | ||||
measures | id_eti_fk | int8 | 19 | ||||
measures | id_msr | bigserial | 19 | √ | nextval('demo.measures_id_msr_seq'::regclass) | ||
measures | id_pro_fk | int4 | 10 | ||||
measures | id_qi_fk | int4 | 10 | ||||
measures | val_msr | numeric | 10,6 | ||||
obs_type | desc_oty | varchar | 120 | √ | null | ||
obs_type | id_oty | serial | 10 | √ | nextval('demo.obs_type_id_oty_seq'::regclass) | ||
obs_type | name_oty | varchar | 60 | ||||
observed_properties | constr_opr | varchar | 2147483647 | √ | null | ||
observed_properties | def_opr | varchar | 80 | ||||
observed_properties | desc_opr | text | 2147483647 | √ | null | ||
observed_properties | id_opr | serial | 10 | √ | nextval('demo.obs_pr_id_opr_seq'::regclass) | ||
observed_properties | name_opr | varchar | 60 | ||||
off_proc | id_off_fk | int4 | 10 | ||||
off_proc | id_off_prc | serial | 10 | √ | nextval('demo.off_proc_id_opr_seq'::regclass) | ||
off_proc | id_prc_fk | int4 | 10 | ||||
offerings | active_off | bool | 1 | true | |||
offerings | desc_off | text | 2147483647 | √ | null | ||
offerings | expiration_off | timestamptz | 35,6 | √ | null | ||
offerings | id_off | serial | 10 | √ | nextval('demo.offerings_id_off_seq'::regclass) | ||
offerings | name_off | varchar | 64 | ||||
positions | geom_pos | geometry | 2147483647 | √ | null | ||
positions | id_eti_fk | int8 | 19 | ||||
positions | id_pos | bigserial | 19 | √ | nextval('demo.measures_mobile_id_mmo_seq'::regclass) | ||
positions | id_qi_fk | int4 | 10 | ||||
proc_obs | constr_pro | varchar | 2147483647 | √ | null | ||
proc_obs | id_opr_fk | int4 | 10 | ||||
proc_obs | id_prc_fk | int4 | 10 | ||||
proc_obs | id_pro | serial | 10 | √ | nextval('demo.prc_obs_id_pro_seq'::regclass) | ||
proc_obs | id_uom_fk | int4 | 10 | ||||
procedures | assignedid_prc | varchar | 32 | ||||
procedures | desc_prc | text | 2147483647 | √ | null | ||
procedures | etime_prc | timestamptz | 35,6 | √ | null | ||
procedures | id_foi_fk | int4 | 10 | √ | null | ||
procedures | id_oty_fk | int4 | 10 | √ | null | ||
procedures | id_prc | serial | 10 | √ | nextval('demo.procedures_id_prc_seq'::regclass) | ||
procedures | name_prc | varchar | 30 | ||||
procedures | stime_prc | timestamptz | 35,6 | √ | null | ||
procedures | time_acq_prc | int4 | 10 | √ | null | ||
procedures | time_res_prc | int4 | 10 | √ | null | ||
quality_index | desc_qi | text | 2147483647 | √ | null | ||
quality_index | id_qi | int4 | 10 | ||||
quality_index | name_qi | varchar | 25 | ||||
tran_log | begin_trl | timestamptz | 35,6 | √ | null | ||
tran_log | count | int4 | 10 | √ | null | ||
tran_log | end_trl | timestamptz | 35,6 | √ | null | ||
tran_log | etime_prc | timestamptz | 35,6 | √ | null | ||
tran_log | id_trl | serial | 10 | √ | nextval('demo.tran_log_id_trl_seq'::regclass) | ||
tran_log | operation_trl | varchar | 2147483647 | ||||
tran_log | procedure_trl | varchar | 30 | ||||
tran_log | stime_prc | timestamptz | 35,6 | √ | null | ||
tran_log | transaction_time_trl | timestamp | 29,6 | √ | now() | ||
uoms | desc_uom | text | 2147483647 | √ | null | ||
uoms | id_uom | serial | 10 | √ | nextval('demo.uoms_id_uom_seq'::regclass) | ||
uoms | name_uom | varchar | 20 |