Hotel-teamproject
테이블 (10)
고객 (User)
- user_id (Key) — INT AUTO_INCREMENT — 기본 키 — NOT NULL
- email (Field) — VARCHAR(255) — NOT NULL
- password (Field2) — VARCHAR(255) — NOT NULL
- name (Field3) — VARCHAR(100) — NOT NULL
- phone_number (Field4) — VARCHAR(20) — NOT NULL
- address (Field5) — TEXT — NOT NULL
- birthdate (Field6) — DATE — NOT NULL
- profile_image_url (Field7) — VARCHAR(255)
- status (Field8) — VARCHAR(20) DEFAULT 'ACTIVE' — NOT NULL
- created_at (Field9) — DATETIME DEFAULT NOW() — NOT NULL
공지사항 (Notice)
- notice_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- admin_id (Field) — VARCHAR(50) — NOT NULL — fk-admin
- title (Field2) — VARCHAR(100) — NOT NULL
- content (Field3) — TEXT — NOT NULL
- created_at (Field4) — DATETIME — NOT NULL
관리자 (Admin)
- admin_id (Key) — VARCHAR(50) — 기본 키 — NOT NULL
- username (Field) — VARCHAR(50) — NOT NULL
- password (Field2) — VARCHAR(255) — NOT NULL
- name (Field3) — VARCHAR(50) — NOT NULL
- role (Field4) — VARCHAR(20) — NOT NULL
등록된 결제수단 (UserPaymentMethod)
- method_id (Key) — INT AUTO_INCREMENT — 기본 키 — NOT NULL
- user_id (Field) — INT — NOT NULL — fk
- payment_type (Field2) — VARCHAR(50) — NOT NULL
- billing_key (Field3) — VARCHAR(255) — NOT NULL
- card_info (Field4) — VARCHAR(100)
- is_default (Field5) — TINYINT(1) DEFAULT 0 — NOT NULL
- created_at (Field6) — DATETIME DEFAULT NOW() — NOT NULL
리뷰 (Review)
- review_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- reservation_id (Field) — BIGINT — NOT NULL — fk-reservation
- user_id (Field2) — VARCHAR(50) — NOT NULL — fk-user
- hotel_id (Field3) — BIGINT — NOT NULL — fk-hotel
- rating (Field4) — TINYINT — NOT NULL
- comment (Field5) — TEXT
- created_at (Field6) — DATETIME — NOT NULL
리뷰 답글 (ReviewReply)
- reply_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- review_id (Field) — BIGINT — NOT NULL — fk-review
- partner_id (Field2) — VARCHAR(50) — NOT NULL — fk-partner
- comment (Field3) — TEXT — NOT NULL
- created_at (Field4) — DATETIME — NOT NULL
소셜 로그인 연동 (SocialAccount)
- social_account_id (Key) — INT AUTO_INCREMENT — 기본 키 — NOT NULL
- user_id (Field) — INT — NOT NULL — fk
- provider (Field2) — VARCHAR(50) — NOT NULL
- provider_id (Field3) — VARCHAR(255) — NOT NULL
- created_at (Field4) — DATETIME DEFAULT NOW() — NOT NULL
유저 보유 쿠폰 (UserCoupon)
- user_coupon_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- user_id (Field) — VARCHAR(50) — NOT NULL — fk-user
- coupon_id (Field2) — BIGINT — NOT NULL — fk-coupon
- is_used (Field3) — BOOLEAN — NOT NULL
- used_at (Field4) — DATETIME
쿠폰 (Coupon)
- coupon_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
- admin_id (Field) — VARCHAR(50) — NOT NULL — fk-admin
- code (Field2) — VARCHAR(50) — NOT NULL
- discount_type (Field3) — VARCHAR(20) — NOT NULL
- discount_value (Field4) — INT — NOT NULL
- valid_from (Field5) — DATETIME — NOT NULL
- valid_to (Field6) — DATETIIME — NOT NULL
- status (Field7) — TINYINT — NOT NULL
호텔 파트너 (Partner)
- partner_id (Key) — 기본 키 — NOT NULL
- email (Field)
- password (Field2)
- business_registration_number (Field3)
- status (Field4)
- created_at (Field5)