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