yanolja
Tables (20)
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)
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 — VARCHAR(500)
- discount_type — VARCHAR(20) — NOT NULL
- discount_value — DECIMAL(12, 2) — NOT NULL
- max_discount_amount — DECIMAL(12, 2)
- min_order_amount — DECIMAL(12, 2)
- issue_count — INT — NOT NULL
- used_count — INT — NOT NULL
- issue_start_at — TIMESTAMP — NOT NULL
- issue_end_at — TIMESTAMP — NOT NULL
- valid_from — TIMESTAMP — NOT NULL
- valid_until — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
- issue_type — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
order_coupons
- id — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- user_coupon_id — BIGINT — Foreign key → user_coupons.id — NOT NULL
- discount_amount — DECIMAL(12, 2) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
orders
- id (Key) — BIGINT — Primary key — NOT NULL
- order_number — VARCHAR(50) — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- reservation_id — BIGINT — Foreign key → reservations.id — NOT NULL
- original_amount — DECIMAL(12, 2) — NOT NULL
- discount_amount — DECIMAL(12, 2)
- points_used — INT
- final_amount — DECIMAL(12, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- expired_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
payments
- id — BIGINT — Primary key — NOT NULL
- payment_key — VARCHAR(100) — NOT NULL
- order_id (Key) — BIGINT — Foreign key → orders.id — NOT NULL
- payment_method — VARCHAR(20) — NOT NULL
- amount — DECIMAL(12, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- pg_provider — VARCHAR(50)
- pg_transaction_id — VARCHAR(200)
- approval_number — VARCHAR(100)
- card_number — VARCHAR(20)
- card_type — VARCHAR(50)
- installment_months — INT
- paid_at — TIMESTAMP
- failure_reason — VARCHAR(500)
- receipt_url — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- created_by — VARCHAR(255)
- updated_by — VARCHAR(255)
points
- id — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- transaction_type — VARCHAR(20) — NOT NULL
- amount — INT — NOT NULL
- balance — INT — NOT NULL
- description — VARCHAR(500)
- order_id — BIGINT
- expired_at — TIMESTAMP
- status — VARCHAR(20) — NOT NULL
- 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
- status — VARCHAR(20) — NOT NULL
- used_at — TIMESTAMP
- order_id — BIGINT
- created_at — TIMESTAMP
- updated_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)