21 lines
705 B
SQL
21 lines
705 B
SQL
format
|
|
CREATE TABLE public.seedkeywordusage (
|
|
usage_id int4(32,0) NOT NULL,
|
|
keyword_id int4(32,0) NOT NULL,
|
|
import_id int4(32,0) NOT NULL,
|
|
source_type varchar(50),
|
|
used_date timestamp DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
(1 row)
|
|
format
|
|
ALTER TABLE public.seedkeywordusage ADD CONSTRAINT seedkeywordusage_pkey PRIMARY KEY (usage_id);
|
|
(1 row)
|
|
format
|
|
ALTER TABLE public.seedkeywordusage ADD CONSTRAINT seedkeywordusage_import_id_fkey FOREIGN KEY (import_id) REFERENCES public.importhistory (import_id);
|
|
ALTER TABLE public.seedkeywordusage ADD CONSTRAINT seedkeywordusage_keyword_id_fkey FOREIGN KEY (keyword_id) REFERENCES public.keywords (keyword_id);
|
|
(2 rows)
|
|
format
|
|
(0 rows)
|
|
?column?
|
|
(0 rows)
|