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)