240923 23주차 월요일 - 부트 개인 플젝 01

 
 
CREATE TABLE answer_board (
aGroupKind VARCHAR2(255), –
aId NUMBER PRIMARY KEY,
aName VARCHAR2(255) NOT NULL,
aTitle VARCHAR2(255) NOT NULL,
aContent VARCHAR2(4000) NOT NULL,
aEtc VARCHAR2(4000) NULL,
aWriteTime DATE DEFAULT sysdate,
aUpdateTime DATE DEFAULT null,
aHit NUMBER DEFAULT 0,
aDelete VARCHAR2(1) DEFAULT 'N',
aLike NUMBER DEFAULT 0
aName 외래키 nickname
);
create sequence aId;
 
 
CREATE SEQUENCE rId;

drop table reply;
CREATE TABLE reply (
rId NUMBER PRIMARY KEY,
aId NUMBER NOT NULL,
rContent VARCHAR2(1000) NOT NULL,
rName VARCHAR2(100) NOT NULL,
rWriteTime date DEFAULT sysdate,
rUpdateTime date,
rEtc VARCHAR2(1000),
rGroup NUMBER NOT NULL,
rStep NUMBER DEFAULT 0,
rIndent NUMBER DEFAULT 0,
rDelete CHAR(1) DEFAULT 'N',
rLike NUMBER DEFAULT 0
);