public.original_identifiers_history¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| original_identifiers_id | integer | nextval('original_identifiers_history_original_identifiers_id_seq'::regclass) | false | |||
| updated_ln | varchar(100) | NULL::character varying | true | |||
| original_identifier | varchar(100) | NULL::character varying | true | |||
| init_date | timestamp without time zone | true | ||||
| created_by | varchar(255) | false | ||||
| previous_ln | varchar(100) | NULL::character varying | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| original_identifiers_history_pkey | PRIMARY KEY | PRIMARY KEY (original_identifiers_id) |
Indexes¶
| Name | Definition |
|---|---|
| original_identifiers_history_pkey | CREATE UNIQUE INDEX original_identifiers_history_pkey ON public.original_identifiers_history USING btree (original_identifiers_id) |
| original_identifiers_id_idx | CREATE UNIQUE INDEX original_identifiers_id_idx ON public.original_identifiers_history USING btree (original_identifiers_id) |
| original_identifiers_history_ln_idx | CREATE INDEX original_identifiers_history_ln_idx ON public.original_identifiers_history USING btree (updated_ln) |
| original_identifiers_history_original_identifier_idx | CREATE INDEX original_identifiers_history_original_identifier_idx ON public.original_identifiers_history USING btree (original_identifier) |
Relations¶
Generated by [tbls](https://github.com/k1LoW/tbls)