시즈니투어

테이블 (18)

activity

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • name — varchar(20) — NOT NULL

member

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • name — varchar(255) — NOT NULL

place

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • address — varchar(255) — NOT NULL
  • description — longtext — NOT NULL
  • images — longtext — NOT NULL
  • name — varchar(100) — NOT NULL
  • point — geometry — NOT NULL
  • rating — double — NOT NULL
  • region_id — bigint(20) — NOT NULL
  • title — varchar(200) — NOT NULL
  • visit_date — char(8) — NOT NULL

place_activity

  • activity_id — bigint(20) — 기본 키 — NOT NULL
  • place_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

place_like

  • place_id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

place_type

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • name — varchar(50) — NOT NULL

place_type_group

  • place_id — bigint(20) — 기본 키 — NOT NULL
  • place_type_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

place_unit

  • place_id — bigint(20) — 기본 키 — NOT NULL
  • unit_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

region

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • name — varchar(20) — NOT NULL
  • upper_region_id — bigint(20)

tag

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • name — varchar(100) — NOT NULL

tag_place

  • place_id — bigint(20) — 기본 키 — NOT NULL
  • tag_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

tour

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • favorites — int(11) — NOT NULL
  • from — datetime — NOT NULL
  • is_done — bit(1) — NOT NULL
  • name — varchar(50) — NOT NULL
  • recommends — int(11) — NOT NULL
  • region_id — bigint(20) — NOT NULL
  • scope — varchar(255)
  • to — datetime — NOT NULL

tour_notification

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • scheduled_at — datetime — NOT NULL
  • sended_at — datetime
  • tour_id — bigint(20) — NOT NULL
  • user_id — binary(255) — NOT NULL

tour_place

  • place_id — bigint(20) — 기본 키 — NOT NULL
  • tour_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • budget — int(11) — NOT NULL
  • description — varchar(255) — NOT NULL
  • from — datetime — NOT NULL
  • to — datetime — NOT NULL

tourist

  • tour_id — bigint(20) — 기본 키 — NOT NULL
  • user_id — binary(255) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

unit

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • name — varchar(20) — NOT NULL

unit_member

  • member_id — bigint(20) — 기본 키 — NOT NULL
  • unit_id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime

user

  • id — varchar(255) — 기본 키 — NOT NULL
  • created_at — datetime — NOT NULL
  • deleted_at — datetime
  • display_name — varchar(30) — NOT NULL
  • email — varchar(100) — NOT NULL
  • fcm_token — varchar(200)
  • role — varchar(255)
  • twitter_id — varchar(30)