◆ COMMENTS ( 댓글 ) 테이블 생성 및 데이타 삽입 > ORACLE

CREATE TABLE COMMENTS ( 

id NUMBER,

content LONG,

writer VARCHAR2(20),

signdate TIMESTAMP,

table_id NUMBER, --부모 테이블 ID

table_name VARCHAR2(20) --부모 테이블 명

);

insert into COMMENTS values(1,'댓글 첫번째','3333','2023-04-01 18:28:47',1,'NOTIEC');

insert into COMMENTS values(2,'두번째 댓글','3333','2023-04-01 18:28:47',1,'NOTIEC');

insert into COMMENTS values(3,'댓글 단다','3333','2023-04-01 18:28:47',3,'NOTIEC');

COMMIT;