스백정
테이블 (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)