test

Tables (10)

accommodation

  • id — INT — Primary key
  • name — VARCHAR(100)
  • address — VARCHAR(255)
  • area — VARCHAR(50)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • type — VARCHAR(50)
  • price_category — VARCHAR(20)
  • description — TEXT
  • thumbnail_url — VARCHAR(255)
  • created_at — DATETIME

accommodation_category

  • id — INT
  • name — VARCHAR(50) — NOT NULL

accommodation_category_map

  • accommodation_id — BIGINT
  • category_id — INT

accommodation_image

  • id — INT — Primary key
  • accommodation_id — INT
  • image_url — VARCHAR(255)

accommodation_review

  • id — INT — Primary key
  • accommodation_id — INT
  • user_id — INT
  • rating — INT
  • comment — TEXT — EX
  • created_at — DATETIME

bookmark

  • user_id — BIGINT
  • accommodation_id — BIGINT
  • created_at — DATETIME

favorite

  • id — INT — Primary key
  • user_id — INT
  • accommodation_id — INT
  • created_at — DATETIME

review

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • accommodation_id — BIGINT — NOT NULL
  • rating — INT
  • comment — TEXT — EX
  • created_at — DATETIME

user

  • id — BIGINT
  • username — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • email — VARCHAR(255)

users

  • id — INT — Primary key
  • username — VARCHAR(50)
  • password — VARCHAR(255)
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • role — VARCHAR(20)
  • created_at — DATETIME