yanolja
Tables (17)
accommodation_amenities
- id — BIGINT — Primary key — NOT NULL
- accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
- amentiy_id — BIGINT — Foreign key → amenities.id — NOT NULL
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
accommodation_images
- id — BIGINT — Primary key — NOT NULL
- accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- is_main — BOOLEAN
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
- Field
accommodations
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- address — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10, 8)
- longitude — DECIMAL(11, 8)
- price_per_night — DECIMAL(10, 2) — NOT NULL
- rating — DECIMAL(3, 2)
- review_count — INT
- status — VARCHAR(20)
- deleted_yn — VARCHAR(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
amenities
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- icon_url — VARCHAR(255)
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
coupons
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- discount_type — VARCHAR(20) — NOT NULL
- discount_value — DECIMAL(10, 2) — NOT NULL
- min_purchase_amount — DECIMAL(10, 2)
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
payments
- id — BIGINT — Primary key — NOT NULL
- reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- payment_method — VARCHAR(20) — NOT NULL
- status — VARCHAR(20)
- transaction_id — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
reservation_options
- id — BIGINT — Primary key — NOT NULL
- reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
- option_id — BIGINT — Foreign key → room_options.id — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
reservations
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20)
- payment_status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
review_images
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
reviews
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
- reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
room_images
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- is_main — BOOLEAN
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
room_option_mappings
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → rooms.id — NOT NULL
- option_id — BIGINT — Foreign key → room_options.id — NOT NULL
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
room_options
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
rooms
- id — BIGINT — Primary key — NOT NULL
- accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- capacity — INT — NOT NULL
- price_per_night — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
user_coupons
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- coupon_id — BIGINT — Foreign key → coupons.id — NOT NULL
- is_used — BOOLEAN
- used_at — TIMESTAMP
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- role — VARCHAR(20)
- profile_image_url — VARCHAR(255)
- social_provider — VARCHAR(20)
- social_id — VARCHAR(255)
- withdrawal_yn — VARCHAR(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
wishlists
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- accommodation_id — BIGINT — Foreign key → accommodations.id — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)