가서뭐해?

테이블 (6)

Copy Of Copy Of user2 (participant)

  • id — BIGINT — 기본 키 — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • id (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
  • id (travel_id) — BIGINT — 외래 키 → Copy Of user.id — NOT NULL

Copy Of user (travel)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (destination) — varchar(50) — NOT NULL
  • Field (start_date) — DATE — NOT NULL
  • Field (end_date) — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

Copy Of user2 (schedule)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (date) — DATE — NOT NULL
  • Field (start_time) — TIME — NOT NULL
  • Field (end_time) — TIME — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • id (travel_id) — BIGINT — 외래 키 → Copy Of user.id — NOT NULL
  • id (place_id) — BIGINT — 외래 키 → Copy Of user3.id — NOT NULL

Copy Of user3 (place)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field (thumbnail) — VARCHAR(200)
  • Field (address) — VARCHAR(100) — NOT NULL
  • Field (roadAddress) — VARCHAR(100) — NOT NULL
  • Field (category) — VARCHAR(100) — NOT NULL
  • Field (phone) — VARCHAR(100)
  • Field (url) — VARCHAR(100)
  • Field (x) — DECIMAL(9, 6) — NOT NULL
  • Field (y) — DECIMAL(9, 6) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

Copy Of user4 (review)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (rating) — TINYINT — NOT NULL
  • Field (content) — TEXT — NOT NULL
  • Field (image) — VARCHAR(200)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • id (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
  • id (place_id) — BIGINT — 외래 키 → Copy Of user3.id — NOT NULL

user

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field (email) — VARCHAR(50) — NOT NULL
  • Field (password) — VARCHAR(100) — NOT NULL
  • Field (profile_image) — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP