zz-tour

Tables (5)

admin_user

  • id — varchar(12) — Primary key — NOT NULL
  • username — varchar(20) — NOT NULL
  • email — varchar(45) — NOT NULL
  • pwd_hash — varchar(45) — NOT NULL
  • created_dt — datetime
  • updated_dt — datetime

holiday

  • id — int — Primary key — NOT NULL
  • holiday_type — varchar(10) — NOT NULL — day(매주 휴일), except(특정일 제외), date(특정일 지정)
  • holiday_date — varchar(45) — NOT NULL

id_sequence

  • id — varchar(6) — Primary key — NOT NULL — 시퀀스 id
  • no — int — NOT NULL — 시퀀스 no

tour_reservation

  • id — varchar(12) — Primary key — NOT NULL
  • user_id — varchar(12) — Foreign key → user.id — NOT NULL
  • tour_date — date — NOT NULL
  • approval — tinyint — NOT NULL
  • cancel — tinyint
  • status_text — varchar(45) — 예약, 예약 대기, 예약 취소
  • created_dt — datetime
  • updated_dt — datetime

user

  • id — varchar(12) — Primary key — NOT NULL
  • username — varchar(20) — NOT NULL
  • email — varchar(45) — NOT NULL
  • pwd_hash — varchar(45) — NOT NULL
  • created_dt — datetime
  • updated_dt — datetime