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)