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