해외사업본부

테이블 (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)