스백정

테이블 (3)

Message

  • message_id — BIGINT — 기본 키
  • sender_id — BIGINT — NOT NULL
  • receiver_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(2083)
  • sent_at — TIMESTAMP
  • read_at — TIMESTAMP
  • post_id — BIGINT

Post

  • post_id — BIGINT — 기본 키
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • accommodation_name — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • reservation_platform — VARCHAR(255) — NOT NULL
  • image_url — TEXT
  • number_of_people — TINYINT — NOT NULL
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • user_id — BIGINT — 기본 키
  • user_uuid — CHAR(36) — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • nickname — VARCHAR(100)
  • image_url — VARCHAR(2083)
  • password — VARCHAR(255)
  • oauth_provider — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • role — VARCHAR(50)