logit

테이블 (6)

place

  • place_id — bigint — 기본 키 — NOT NULL
  • tour_id — bigint — NOT NULL
  • content — varchar(500) — NOT NULL
  • image_url — text
  • Field3 — VARCHAR(255)
  • Field4 — varchar(100)
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • order — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — varchar(100) — NOT NULL

tour

  • tour_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • name — varchar(100) — NOT NULL
  • budget — int — NOT NULL
  • start_date — datetime
  • time — int — NOT NULL
  • image_url — text — NOT NULL
  • content — varchar(5000) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — varchar(100) — NOT NULL

tour_category

  • tour_category_id — bigint — 기본 키 — NOT NULL
  • tour_id — bigint — NOT NULL
  • category_id2 — bigint — NOT NULL
  • name — varchat(100) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — varchar(100) — NOT NULL

user_language

  • user_language_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — NOT NULL
  • language_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — varchar(100) — NOT NULL

user_review

  • user_review_id — bigint — 기본 키 — NOT NULL
  • review_id — VARCHAR(255) — NOT NULL
  • user_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status — varchar(100) — NOT NULL

사용자 (User)

  • 유저ID (user_id) — bigint — 기본 키 — NOT NULL
  • 이메일 (email) — varchar(100) — NOT NULL
  • 비밀번호 (password) — varchar(255) — NOT NULL
  • 이름 (name) — varchar(100) — NOT NULL
  • 성별 (gender) — varchar(100) — NOT NULL