SQL/Postgresql
date timestamp default 사용
아직미정임
2022. 3. 23. 00:48
date timestamp default current_timestamp -> 현재시간이 자동으로 들어간다.
create sequence eventweb_id_seq;
CREATE TABLE eventweb(
id integer not null default nextval('eventweb_id_seq'::regclass),
title character varying(10485760) COLLATE pg_catalog."default",
subject character varying(10485760) COLLATE pg_catalog."default",
date timestamp default current_timestamp,
adminid character varying(256) COLLATE pg_catalog."default",
active boolean,
image character varying(256),
CONSTRAINT eventweb_pkey PRIMARY KEY (id)
);