eb
Tables (20)
tb_admin
- admin_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(36) — NOT NULL
- user_name — VARCHAR(36) — NOT NULL
- password — VARCHAR(350) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tb_admin_free_board_mapping
- id — INT — Primary key — NOT NULL
- admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
- board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL
tb_admin_free_comment_mapping
- id — INT — Primary key — NOT NULL
- admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
- comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
- board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL
tb_admin_gallery_board_mapping
- id — INT — Primary key — NOT NULL
- admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
- board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL
tb_admin_gallery_comment_mapping
- id — INT — Primary key — NOT NULL
- admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
- comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
- board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL
tb_admin_inquiry_comment_mapping
- id — INT — Primary key — NOT NULL
- admin_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
- comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
- board_id — INT — Foreign key → tb_inquiry_board.board_id — NOT NULL
tb_category
- category_id — INT — Primary key — NOT NULL
- category_name — VARCHAR(36) — NOT NULL
- board_type — VARCHAR(36) — NOT NULL
tb_comment
- comment_id — INT — Primary key — NOT NULL
- content — VARCHAR(350) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
tb_file
- file_id — INT — Primary key — NOT NULL
- original_name — VARCHAR(128) — NOT NULL
- physical_name — VARCHAR(128) — NOT NULL
- file_path — VARCHAR(128) — NOT NULL
- extension — VARCHAR(16) — NOT NULL
- size — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
tb_free_board
- board_id — INT — Primary key — NOT NULL
- category_id — INT — Foreign key → tb_category.category_id — NOT NULL
- title — VARCHAR(350) — NOT NULL
- content — VARCHAR(350) — NOT NULL
- views — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
tb_free_file_mapping
- id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL
- file_id — INT — Foreign key → tb_file.file_id — NOT NULL
tb_gallery_board
- board_id — INT — Primary key — NOT NULL
- category_id — INT — Foreign key → tb_category.category_id — NOT NULL
- title — VARCHAR(350) — NOT NULL
- content — VARCHAR(350) — NOT NULL
- views — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
tb_gallery_file_mapping
- id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL
- file_id — INT — Foreign key → tb_file.file_id — NOT NULL
tb_inquiry_board
- board_id — INT — Primary key — NOT NULL
- author_id — INT — Foreign key → tb_member.member_id — NOT NULL
- title — VARCHAR(350) — NOT NULL
- content — VARCHAR(350) — NOT NULL
- views — INT — NOT NULL
- secret — TINYINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
tb_member
- member_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(36) — NOT NULL
- user_name — VARCHAR(36) — NOT NULL
- password — VARCHAR(350) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tb_member_free_comment_mapping
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → tb_member.member_id — NOT NULL
- comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
- board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL
tb_member_free_mapping
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → tb_member.member_id — NOT NULL
- board_id — INT — Foreign key → tb_free_board.board_id — NOT NULL
tb_member_gallery_comment_mapping
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → tb_member.member_id — NOT NULL
- comment_id — INT — Foreign key → tb_comment.comment_id — NOT NULL
- board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL
tb_member_gallery_mapping
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → tb_member.member_id — NOT NULL
- board_id — INT — Foreign key → tb_gallery_board.board_id — NOT NULL
tb_notice_board
- board_id — INT — Primary key — NOT NULL
- category_id — INT — Foreign key → tb_category.category_id — NOT NULL
- author_id — INT — Foreign key → tb_admin.admin_id — NOT NULL
- title — VARCHAR(350) — NOT NULL
- content — VARCHAR(350) — NOT NULL
- views — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- edited_at — TIMESTAMP
- fixed — TINYINT — NOT NULL