CCTV
Tables (4)
Answer (답변)
- Answer_Index (답변_인덱스) — INT — Primary key — NOT NULL
- Answer_Title (답변_제목) — vChar(100)
- Answer_Text (답변_본문) — Text
- Answer_Views (답변_조회수) — INT
- Board_Index (게시판_인덱스) — INT — Foreign key → Board.Board_Index — NOT NULL
Board (게시판)
- Board_Index (게시판_인덱스) — INT — Primary key — NOT NULL
- User_id (유저_아이디) — char(15) — Foreign key → Users.User_id — NOT NULL
- Board_Title (게시판_제목) — vchar(30)
- Board_Text (게시판_본문) — Text
- Board_Good (게시판_추천) — INT
- Board_Comments (게시판_댓글수) — INT
- Board_Views (게시판_조회수) — INT
Comment (댓글)
- Comments_Index (댓글_번호) — INT — Primary key — NOT NULL
- Comments_Num (댓글_인덱스) — INT
- Comments_Text (댓글_텍스트) — Text
- User_id (유저_아이디) — char(15) — Foreign key → Users.User_id — NOT NULL
- Board_Index (게시판_인덱스) — INT — Foreign key → Board.Board_Index — NOT NULL
Users (회원)
- User_id (유저_아이디) — char(15) — Primary key — NOT NULL
- User_name (유저_이름) — vchar(10)