BackEnd
REFERENCES 외래키 주기
아직미정임
2022. 3. 24. 14:29
create sequence product_id_seq;
create sequence product_idx_seq;
create table product(
id integer not null default nextval('product_id_seq'::regclass),
idx integer not null default nextval('product_idx_seq'::regclass),
company character varying(256) )REFERENCES companies ("company") on delete cascade COLLATE pg_catalog."default",
title character varying(10485760) COLLATE pg_catalog."default",
price double precision,
couponCount integer,
guidance character varying(10485760) COLLATE pg_catalog."default",
category character varying(256) COLLATE pg_catalog."default",
mainimg character varying(256) COLLATE pg_catalog."default",
subimgs character varying(256) COLLATE pg_catalog."default",
updatetime timestamp default current_timestamp,
CONSTRAINT product_pkey PRIMARY KEY (id),
CONSTRAINT product_unique UNIQUE (idx)
);
REFERENCES companies ("company") on delete cascade On deletde cascade -> 자동으로 같이 지워주는 속성