intern_board
Tables (8)
TB_BOARD (tb_board)
- BOARD_ID (bid) — INT(6) — Primary key — NOT NULL
- MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL
- BOARD_TITLE (title) — varchar(70) — NOT NULL
- BOARD_CONTENT (content) — varchar(350) — NOT NULL
- BOARD_LIKE (like) — int(6) — NOT NULL
- BOARD_HATE (hate) — int(6) — NOT NULL
- BOARD_VIEW (view) — int(6) — NOT NULL
- BOARD_REGDATE (regdate) — date — NOT NULL
- BOARD_UPDATE (update) — date
TB_BOARD_HATE (tb_boardhate)
- BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
- MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL — NOT NULL
TB_BOARD_LIKE (tb_boardlike)
- BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
- MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL — NOT NULL
TB_COMMENT (tb_comment)
- COMMENT_ID (cid) — INT(6) — Primary key — NOT NULL
- BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
- MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL
- COMMENT_CONTENT (content) — varchar(150) — NOT NULL
- COMMENT_LIKE (like) — int(6) — NOT NULL
- COMMENT_HATE (hate) — int(6) — NOT NULL
- COMMENT_REGDATE (regdate) — datetime — NOT NULL
- COMMENT_UPDATE (update) — datetime
- COMMENT_GRP (grp) — int(6)
- COMMENT_FLOW (flow) — int(6)
TB_COMMENT_HATE (tb_commenthate)
- COMMENT_ID (cid) — INT(6) — Foreign key → TB_COMMENT.COMMENT_ID — NOT NULL
- MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_COMMENT.MEMBER_EMAIL
TB_COMMENT_LIKE (tb_commentlike)
- COMMENT_ID (cid) — INT(6) — Foreign key → TB_COMMENT.COMMENT_ID — NOT NULL
- MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_COMMENT.MEMBER_EMAIL
TB_FILE (tb_file)
- FILE_ID (fid) — varchar(32) — Primary key — NOT NULL
- BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
- FILE_NAME (name) — varchar(70) — NOT NULL
- FILE_PATH (path) — varchar(100) — NOT NULL
- FILE_EXTENSION (extension) — varchar(10) — NOT NULL
- FILE_DOWN (down) — int(10) — NOT NULL
TB_MEMBER (tb_member)
- MEMBER_EMAIL (email) — varchar(50) — Primary key — NOT NULL
- MEMBER_PASSWORD (password) — varchar(50) — NOT NULL
- MEMBER_NICKNAME (nickname) — varchar(30) — NOT NULL