MOEUMC

Tables (8)

exhibition

  • PK (id) — bigint — Primary key — NOT NULL — auto increment
  • FK (region_id) — bigint — Foreign key → region.PK — NOT NULL — auto increment
  • (name) — varchar(100) — NOT NULL — 전시회 이름
  • (place) — varchar(100) — NOT NULL
  • (description) — varchar(300)
  • (start_date) — date — NOT NULL
  • (end_date) — date — NOT NULL
  • (search_date) — datetime(6)
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL

follow

  • PK (id) — bigint — Primary key — NOT NULL — auto increment
  • FK (user_id) — bigint — Foreign key → user.PK — NOT NULL — auto increment
  • FK (exhibition_id) — bigint — Foreign key → exhibition.PK — NOT NULL — auto increment
  • FK (popup_store_id) — bigint — Foreign key → popup_store.PK — NOT NULL — auto increment
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL

photo

  • PK (id) — bigint — Primary key — NOT NULL
  • PK (popup_store_id) — bigint — Foreign key → popup_store.PK — NOT NULL — auto increment
  • PK (exhibition_id) — bigint — Foreign key → exhibition.PK — NOT NULL — auto increment
  • (photo) — text — NOT NULL — 사진 정보
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL

popup_store

  • PK (id) — bigint — Primary key — NOT NULL — auto increment
  • FK (region_id) — bigint — Foreign key → region.PK — NOT NULL — auto increment
  • (name) — varchar(100) — NOT NULL — 팝업이룸
  • (place) — varchar(100) — NOT NULL
  • (decription) — varchar(300)
  • (start_date) — date — NOT NULL
  • (end_date) — date — NOT NULL
  • (search_date) — datetime(6)
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL

record_page

  • PK (id) — bigint — Primary key — NOT NULL — auto increment
  • FK (user_id) — bigint — Foreign key → user.PK — NOT NULL — auto increment
  • FK (exhibition_id) — bigint — Foreign key → exhibition.PK — NOT NULL — auto increment
  • FK (popup_store_id) — bigint — Foreign key → popup_store.PK — NOT NULL — auto increment
  • (status) — enum — NOT NULL — 티켓인증, 미인증 상태 확인
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL

record_photo

  • PK (id) — bigint — Primary key — NOT NULL
  • FK (record_page_id) — bigint — Foreign key → record_page.PK — NOT NULL — auto increment
  • (record_photo) — text — NOT NULL — user가 업로드한 사진
  • (body) — varchar(200)
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL

region

  • PK (id) — bigint — Primary key — NOT NULL — auto increment
  • (city) — enum — NOT NULL — 전체, 서울, 부산
  • (district) — enum — NOT NULL — 전체, 강남구, 강동구, 강서구

user

  • PK (id) — bigint — Primary key — NOT NULL — auto increment
  • (password) — varchar — NOT NULL
  • (phone_number) — varchar(11) — NOT NULL
  • (nickname) — varchar(100) — NOT NULL
  • (email) — varchar(100)
  • (provider) — enum
  • (provider_id) — int
  • (status) — enum
  • (inactive_date) — datetime(6)
  • (created_at) — datetime(6) — NOT NULL
  • (updated_at) — datetime(6) — NOT NULL