new딸기축제
테이블 (23)
admin_activity_log
- act_log_id — bigint(20) — 기본 키 — NOT NULL
- admin_id — bigint(20) — 외래 키 → admin_user.admin_id — NOT NULL
- occurred_at — datetime(6) — NOT NULL
- target_id — bigint(20)
- ip_address — varchar(45)
- target_type — varchar(80)
- action_type — varchar(100) — NOT NULL
- message — varchar(255) — NOT NULL
- path — varchar(255)
admin_ip_whitelist
- id — bigint(20) — 기본 키 — NOT NULL
- admin_id — bigint(20) — 외래 키 → admin_user.admin_id — NOT NULL
- ip_address — varchar(50) — NOT NULL
admin_login_audit
- audit_id — bigint(20) — 기본 키 — NOT NULL
- success — bit(1) — NOT NULL
- occurred_at — datetime(6) — NOT NULL
- ip_address — varchar(45)
- username — varchar(60) — NOT NULL
- reason — varchar(120)
- user_agent — varchar(255)
admin_role
- admin_id — bigint(20) — 외래 키 → admin_user.admin_id — NOT NULL
- role_id — bigint(20) — 외래 키 → role.role_id — NOT NULL
admin_session
- session_id — varchar(36) — 기본 키 — NOT NULL
- is_revoked — bit(1) — NOT NULL
- admin_id — bigint(20) — 외래 키 → admin_user.admin_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- expires_at — datetime(6) — NOT NULL
- last_access_at — datetime(6) — NOT NULL
- ip_address — varchar(45)
- user_agent — varchar(255)
admin_user
- admin_id — bigint(20) — 기본 키 — NOT NULL
- is_active — bit(1) — NOT NULL
- approved_at — datetime(6)
- approved_by — bigint(20) — 외래 키 → admin_user.admin_id
- created_at — datetime(6) — NOT NULL
- last_login_at — datetime(6)
- requested_at — datetime(6)
- updated_at — datetime(6) — NOT NULL
- username — varchar(60) — NOT NULL
- name — varchar(80) — NOT NULL
- email — varchar(120) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- approve_status — enum('APPROVED','BLOCKED','PENDING','REJECTED') — NOT NULL
board
- board_id — bigint(20) — 기본 키 — NOT NULL
- status — bit(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by — bigint(20) — 외래 키 → admin_user.admin_id — NOT NULL
- post_count — bigint(20) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- read_role — varchar(20)
- write_role — varchar(20)
- user_id — varchar(30) — 외래 키 → users.user_id
- skin — varchar(50)
- name — varchar(100) — NOT NULL
- visibility — varchar(7) — NOT NULL
booth
- booth_id — bigint(20) — 기본 키 — NOT NULL
- event_date — date — NOT NULL
- status — bit(1)
- current_person — bigint(20)
- max_person — bigint(20) — NOT NULL
- price — bigint(20) — NOT NULL
- priority — bigint(20)
- time — varchar(50)
- location — varchar(200) — NOT NULL
- title — varchar(200) — NOT NULL
- context — varchar(500) — NOT NULL
- img — varchar(500)
booth_img_mapping
- file_id — bigint(20) — 외래 키 → media_file.file_id — NOT NULL
- booth_id — bigint(20) — 외래 키 → booth.booth_id — NOT NULL
gallery_album
- album_id — bigint(20) — 기본 키 — NOT NULL
- is_active — bit(1) — NOT NULL
- category_id — bigint(20) — 외래 키 → gallery_category.category_id — NOT NULL
- cover_file_id — bigint(20) — 외래 키 → media_file.file_id
- create_at — datetime(6) — NOT NULL
- created_by — bigint(20) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- title — varchar(200) — NOT NULL
- visibility — enum('MANAGER','MEMBER','PUBLIC','STAFF','SUPER') — NOT NULL
gallery_category
- category_id — bigint(20) — 기본 키 — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
gallery_item
- item_id — bigint(20) — 기본 키 — NOT NULL
- status — bit(1) — NOT NULL
- admin_id — bigint(20) — NOT NULL
- album_id — bigint(20) — 외래 키 → gallery_album.album_id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- location — varchar(200)
- title — varchar(200)
- caption — varchar(1000)
item_media
- item_id — bigint(20) — 외래 키 → gallery_item.item_id — NOT NULL
- file_id — bigint(20) — 외래 키 → media_file.file_id — NOT NULL
media_file
- file_id — bigint(20) — 기본 키 — NOT NULL
- board_id — bigint(20) — 외래 키 → board.board_id
- duration_sec — bigint(20)
- height — bigint(20)
- post_id — bigint(20) — 외래 키 → post.post_id
- size_bytes — bigint(20)
- weight — bigint(20)
- type — varchar(120) — NOT NULL
- storage_uri — varchar(255) — NOT NULL
- thumb_uri — varchar(255)
- notice_id — bigint(20) — 외래 키 → notice.notice_id
notice
- notice_id — bigint(20) — 기본 키 — NOT NULL
- important — bit(1)
- admin_id — bigint(20) — 외래 키 → admin_user.admin_id
- create_date — datetime(6)
- update_date — datetime(6)
- view_count — bigint(20)
- title — varchar(200) — NOT NULL
- context — text — NOT NULL
notice_img_mapping
- notice_id — bigint(20) — 외래 키 → notice.notice_id — NOT NULL
- file_id — bigint(20) — 외래 키 → media_file.file_id — NOT NULL
post
- post_id — bigint(20) — 기본 키 — NOT NULL
- admin_id — bigint(20) — 외래 키 → admin_user.admin_id
- board_id — bigint(20) — 외래 키 → board.board_id
- create_date — datetime(6)
- update_date — datetime(6)
- view — bigint(20)
- user_id — varchar(30) — 외래 키 → users.user_id
- title — varchar(200) — NOT NULL
- context — varchar(500)
post_img_mapping
- post_id — bigint(20) — 외래 키 → post.post_id — NOT NULL
- file_id — bigint(20) — 외래 키 → media_file.file_id — NOT NULL
reservation
- id — bigint(20) — 기본 키 — NOT NULL
- count — int(11) — NOT NULL
- reser_date — date — NOT NULL
- booth_id — bigint(20) — 외래 키 → booth.booth_id — NOT NULL
- user_id — varchar(30) — 외래 키 → users.user_id — NOT NULL
role
- role_id — bigint(20) — 기본 키 — NOT NULL
- role_code — varchar(50) — NOT NULL
- role_name — varchar(80) — NOT NULL
system_log
- sys_log_id — bigint(20) — 기본 키 — NOT NULL
- occurred_at — datetime(6) — NOT NULL
- status_code — bigint(20)
- ip_address — varchar(45) — NOT NULL
- message — varchar(255) — NOT NULL
- path — varchar(255)
- referrer — varchar(255)
- user_agent — varchar(255)
- level — enum('ERROR','INFO','WARN') — NOT NULL
user_session
- session_id — varchar(36) — 기본 키 — NOT NULL
- is_revoked — bit(1) — NOT NULL
- created_at — timestamp — NOT NULL
- expires_at — datetime(6) — NOT NULL
- user_id — varchar(30) — 외래 키 → users.user_id — NOT NULL
- ip_address — varchar(45)
- refresh_token — varchar(255)
- user_agent — varchar(255)
users
- user_id — varchar(30) — 기본 키 — NOT NULL
- birth_date — date
- is_active — bit(1) — NOT NULL
- is_verified — bit(1) — NOT NULL
- code_valid — datetime(6)
- sex — varchar(10) — NOT NULL
- verify_code — varchar(10)
- phone_number — varchar(20)
- provider — varchar(20)
- role — varchar(20)
- name — varchar(50) — NOT NULL
- nationality — varchar(50)
- nickname — varchar(50)
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- social_id — varchar(255)