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