board
Tables (6)
ADMINS
- admin_id — BIGINT — Primary key — NOT NULL
- admin_login_id — VARCHAR(255) — NOT NULL
- admin_login_password — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
BOARDS
- board_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBERS.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_deleted — BOOLEAN — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- views — BIGINT — NOT NULL
COMMENTS
- comment_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
- member_id — BIGINT — Foreign key → MEMBERS.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_deleted — BOOLEAN — NOT NULL
- content — TEXT — NOT NULL
IMAGES
- image_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
- origin_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- storage_path — VARCHAR(500) — NOT NULL
- extension — VARCHAR(20) — NOT NULL
- file_size — BIGINT — NOT NULL
- sort_order — INT — NOT NULL
- is_thumbnail — BOOLEAN — NOT NULL
LOGS
- log_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → MEMBERS.member_id
- access_time — TIMESTAMP — NOT NULL
- access_ip — VARCHAR(45) — NOT NULL
- login_success — BOOLEAN — NOT NULL
- fail_reason — VARCHAR(255)
MEMBERS
- member_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_deleted — BOOLEAN — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- login_password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- is_banned — BOOLEAN — NOT NULL