JAMJARI

Tables (17)

BOOKING

  • bo_num — INT — Primary key — NOT NULL
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL
  • ro_num — VARCHAR(45) — Foreign key → ROOM.ro_num — NOT NULL
  • fac_id — INT — Foreign key → FACILITY.fac_id — NOT NULL
  • bo_name — VARCHAR(100) — NOT NULL
  • checkin — DATE — NOT NULL
  • checkout — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • payment — DECIMAL(10, 2) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • reg_date — DATE — NOT NULL

BOOKING_PROMO

  • fac_id — INT — Primary key — NOT NULL
  • promo_code — INT — Foreign key → PROMOTION.promo_code — NOT NULL

BUSINESS

  • bu_email — VARCHAR(45) — NOT NULL
  • bu_password — VARCHAR(45) — NOT NULL
  • bu_tel — VARCHAR(15) — NOT NULL
  • bu_name — VARCHAR(100) — NOT NULL
  • bu_addr — VARCHAR(255) — NOT NULL
  • bu_code — VARCHAR(100) — NOT NULL
  • bu_title — VARCHAR(100) — NOT NULL
  • approval — VARCHAR(20) — NOT NULL — `bu_account_num` VARCHAR(30) NOT NULL, PRIMARY KEY (`bu_email`

CALCULATE

  • bu_email — VARCHAR(45) — Foreign key → BUSINESS.bu_email — NOT NULL
  • payment_id — VARCHAR(45) — Foreign key → PAYMENT.payment_id — NOT NULL
  • sum — DECIMAL(10, 2)

CS

  • cs_id — INT — Primary key — NOT NULL
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL
  • cs_title — VARCHAR(100) — NOT NULL
  • cs_text — TEXT — NOT NULL
  • cs_date — DATE — NOT NULL
  • cs_response — TEXT

FACILITY

  • fac_id — INT — Primary key — NOT NULL
  • fac_name — VARCHAR(100) — NOT NULL — 욕조 여부 등등
  • fac_description — TEXT — NOT NULL

MEMBER

  • email — VARCHAR(45) — Primary key — NOT NULL
  • password — VARCHAR(45) — NOT NULL
  • tel — VARCHAR(15) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • admin_check — VARCHAR(10)

NOTICE

  • notice_id — INT — Primary key — NOT NULL
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL
  • notice_title — VARCHAR(100) — NOT NULL
  • notice_text — TEXT
  • notice_date — DATE — NOT NULL

PAYMENT

  • payment_id — VARCHAR(45) — Primary key — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • payment_status — VARCHAR(20) — NOT NULL — 결제 완료, 대기, 취소 상태 표시
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL

PICTURE

  • pic_loca — VARCHAR(100) — Primary key — NOT NULL
  • pic_rum — INT — Primary key — NOT NULL

PROMOTION

  • promo_code — INT — Primary key — NOT NULL
  • discount_amount — DECIMAL(10, 2) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

RESERVED

  • re_date — DATE — Primary key — NOT NULL
  • ro_num — VARCHAR(45) — Foreign key → ROOM.ro_num — NOT NULL

REVIEW

  • rev_num — INT — Primary key — NOT NULL
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL
  • content — TEXT — NOT NULL
  • review_date — DATE — NOT NULL
  • score — INT — NOT NULL
  • content_reply — TEXT
  • report — VARCHAR(20) — NOT NULL
  • bu_email — VARCHAR(45) — Foreign key → BUSINESS.bu_email — NOT NULL

ROOM

  • ro_num — VARCHAR(45) — Primary key — NOT NULL
  • bu_email — VARCHAR(45) — Foreign key → BUSINESS.bu_email — NOT NULL
  • pic_loca — VARCHAR(100) — NOT NULL
  • pic_rum — INT — NOT NULL
  • ro_count — VARCHAR(40) — NOT NULL
  • ro_name — VARCHAR(100) — NOT NULL
  • ro_price — DECIMAL(10, 2) — NOT NULL
  • checkin — TIME — NOT NULL
  • checkout — TIME — NOT NULL
  • ro_info — TEXT
  • max_person — INT — NOT NULL

ROOM_FACILITY

  • fac_id — INT — Foreign key → FACILITY.fac_id — NOT NULL
  • ro_num — VARCHAR(45) — Foreign key → ROOM.ro_num — NOT NULL

SENDING

  • mailcode — VARCHAR(45) — Primary key — NOT NULL
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL
  • bo_num — INT — Foreign key → BOOKING.bo_num — NOT NULL
  • payment_id — VARCHAR(45) — Foreign key → PAYMENT.payment_id — NOT NULL
  • send_date — DATE
  • send_status — VARCHAR(45) — NOT NULL

WISHLIST

  • fac_id — INT — Primary key — NOT NULL
  • email — VARCHAR(45) — Foreign key → MEMBER.email — NOT NULL