| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| maintenance_critic_id | integer | nextval('maintenance_time_criticity_maintenance_critic_id_seq'::regclass) | false | |||
| scope | varchar(0) | false | ||||
| level_id | integer | false | maintenance_level_meta | |||
| start_month | integer | false | ||||
| end_month | integer | false | ||||
| created_by | varchar(0) | false | ||||
| created_on | timestamp without time zone | now() | true |
| Name | Type | Definition |
|---|---|---|
| maintenance_time_criticity_level_id_fkey | FOREIGN KEY | FOREIGN KEY (level_id) REFERENCES maintenance_level_meta(maintenance_level_id) |
| maintenance_time_criticity_pkey | PRIMARY KEY | PRIMARY KEY (maintenance_critic_id) |
| Name | Definition |
|---|---|
| maintenance_time_criticity_pkey | CREATE UNIQUE INDEX maintenance_time_criticity_pkey ON public.maintenance_time_criticity USING btree (maintenance_critic_id) |
| scope_level_idx | CREATE UNIQUE INDEX scope_level_idx ON public.maintenance_time_criticity USING btree (scope, level_id) |
Generated by tbls