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)