ㅇㄱㅇㄷㅁㅇㄴ
Tables (8)
Comments
- comment_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- review_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
Favorites
- favorite_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- location_id — INT — NOT NULL
- created_at — DATETIME
Likes
- like_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- review_id — INT — NOT NULL
- created_at — DATETIME
Locations
- location_id — INT — Primary key — NOT NULL
- category — VARCHAR(50)
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- address — VARCHAR(255)
- postal_code — VARCHAR(10)
- latitude — DECIMAL(9,6)
- longitude — DECIMAL(9,6)
- contact — VARCHAR(20)
- review_count — INT
- favorite_count — INT
- like_count — INT
Messages
- message_id — INT — Primary key — NOT NULL
- sender_id — INT — NOT NULL
- receiver_id — INT — NOT NULL
- subject — VARCHAR(255)
- content — TEXT
- sent_at — DATETIME
- read_at — DATETIME
Reviews
- review_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- location_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — DATETIME
Travel_Schedules
- schedule_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- region — VARCHAR(255)
- route — TEXT
- travel_time — TIME
- schedule_date — DATE
- travel_duration — TIME
- location_id — INT
- theme — VARCHAR(255)
- map_link — TEXT
- created_at — DATETIME
Users
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- contact — VARCHAR(20)
- signup_date — DATETIME
- last_login — DATETIME