해외사업본부
테이블 (6)
북마크 (bookmark)
- bookmark_id — INT — 기본 키 — NOT NULL
- place_id — INT — 외래 키 → 장소.place_id
- user_id — INT — 외래 키 → 장소.user_id
- check — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
이미지 (image)
- image_id — INT — 기본 키 — NOT NULL
- place_id — INT — 외래 키 → 장소.place_id
- image_url — VARCHAR(255)
- type — TINYINT(1)
작품 (work)
- work_id — INT — 기본 키
- work_name — VARCHAR(255) — NOT NULL
- work_season — VARCHAR(50)
- work_ep — VARCHAR(50)
- poster — VARCHAR(255)
- description — TEXT
- start_date — DATE
- end_date — DATE
- genre — VARCHAR(255)
- director — VARCHAR(255)
- series_writer — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
장소 (place)
- place_id — INT — 기본 키
- work_id — INT — 외래 키 → 작품.work_id
- user_id — INT — 외래 키 → 회원.user_id
- place_name — VARCHAR(255) — NOT NULL
- description — TEXT
- address_region — VARCHAR(255)
- address_city — VARCHAR(255)
- address_district — VARCHAR(255)
- detailed_address — VARCHAR(255)
- latitude — DECIMAL(15, 12)
- longitude — DECIMAL(15, 12)
- latestshot_date — DATE
- opening_hours — TEXT
- marker_img — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
필터링 (hashtag)
- hashtag_id — INT — 기본 키 — NOT NULL
- hash_name — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- place_id — INT — 외래 키 → 장소.place_id
- work_id — INT — 외래 키 → 장소.work_id
회원 (user)
- user_id — INT — 기본 키
- google_id — VARCHAR(255)
- user_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- token — VARCHAR(255)
- is_active — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- role — VARCHAR(50)