게시판 DB

테이블 (10)

board

  • board_seq — int — 기본 키 — NOT NULL
  • board_channel_seq — int — 외래 키 → board_channel.board_channel_seq — NOT NULL
  • user_seq — int — 외래 키 → user.user_seq — NOT NULL
  • title — varchar(50)
  • content — varchar(2000)
  • regdate — datetime

board_channel

  • board_channel_seq — int — 기본 키 — NOT NULL
  • name — varchar(20)

board_comment

  • comment_seq — int — 기본 키 — NOT NULL
  • board_seq — int — 외래 키 → board.board_seq — NOT NULL
  • user_seq — int — 외래 키 → user.user_seq — NOT NULL
  • content — varchar(255)
  • regdate — datetime

channel

  • channel_seq — int — 기본 키 — NOT NULL
  • name — varchar(20)

chat

  • chat_seq — int — 기본 키 — NOT NULL
  • channel_seq — int — 외래 키 → channel.channel_seq — NOT NULL
  • type — varchar(10)
  • name — varchar(20)
  • regdate — datetime

message

  • message_seq — int — 기본 키 — NOT NULL
  • user_seq — int — 외래 키 → user.user_seq — NOT NULL
  • chat_seq — int — 외래 키 → chat.chat_seq — NOT NULL
  • content — varchar(255)
  • regdate — datetime
  • isDeleted — char(1)

user

  • user_seq — int — 기본 키 — NOT NULL
  • Id — varchar(50)
  • PW — varchar(50)
  • name — varchar(10)
  • regdate — datetime
  • isDeleted — char(1)

user_board_channel

  • user_seq — int — 외래 키 → user.user_seq — NOT NULL
  • board_channel_seq — int — 외래 키 → board_channel.board_channel_seq — NOT NULL

user_channel

  • user_seq — int — 외래 키 → user.user_seq — NOT NULL
  • channel_seq — int — 외래 키 → channel.channel_seq — NOT NULL

user_chat

  • chat_seq — int — 외래 키 → chat.chat_seq — NOT NULL
  • favorite — char(1)
  • user_seq — int — 외래 키 → user.user_seq — NOT NULL