| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| report_id | integer | nextval('report_report_id_seq'::regclass) | false | |||
| report_type_id | integer | false | report_type | |||
| scope | varchar(0) | false | ||||
| report_metadata | jsonb | false | ||||
| report_data | json | true | ||||
| report_status | report_status | 'PENDING'::report_status | false | |||
| created_by | varchar(0) | false | ||||
| created_on | timestamp without time zone | now() | false |
| Name | Type | Definition |
|---|---|---|
| report_report_type_id_fkey | FOREIGN KEY | FOREIGN KEY (report_type_id) REFERENCES report_type(report_type_id) |
| report_pkey | PRIMARY KEY | PRIMARY KEY (report_id) |
| Name | Definition |
|---|---|
| report_pkey | CREATE UNIQUE INDEX report_pkey ON public.report USING btree (report_id) |
Generated by tbls