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