test

Tables (4)

card

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user.id — NOT NULL
  • company_nm — varchar(20) — NOT NULL — 카드사
  • card_num — varchar(100) — NOT NULL — 카드번호(암호화)
  • business_num — varchar(20) — 사업자번호
  • user_jumin — varchar(100) — 주민번호(암호화)
  • exp_date — date — NOT NULL — 카드 유효기간
  • update_date — datetime
  • deleted — bit(1) — NOT NULL

hotel

  • id — int(11) — Primary key — NOT NULL
  • hotel_nm — varchar(100) — NOT NULL — 호텔이름
  • fee_weekend — int(8) — NOT NULL — 주말 요금
  • fee_weekday — int(8) — NOT NULL — 주중 요금
  • update_date — datetime
  • deleted — bit(1)

reservation

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user.id — NOT NULL
  • hotel_id — int(11) — Foreign key → hotel.id — NOT NULL
  • hotel_nm (hotel_name) — varchar(100) — NOT NULL — 호텔 이름
  • checkin_date — date — NOT NULL — 체크인 날짜
  • checkout_date — date — NOT NULL — 체크아웃 날짜
  • guest_cnt — int(3) — NOT NULL — 투숙객 수
  • guest_nm (guest_name) — varhcar(20) — NOT NULL — 투숙객 성명
  • fee_totle — int(8) — NOT NULL — 결제 총액
  • update_date — datetime
  • deleted — bit(1) — NOT NULL
  • paid_st — bit(1) — NOT NULL — 결제여부
  • paid_at — datetime — 결제 완료 일자

user

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • birth — date — NOT NULL
  • belong — varchar(50) — NOT NULL — 소속
  • phone — varchar(20) — NOT NULL — 연락처
  • email — varchar(50) — NOT NULL
  • update_date — datetime
  • deleted — bit(1) — NOT NULL