게시판 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