관리자페이지
테이블 (8)
admin
- aidx — int(6) — 기본 키 — NOT NULL
- aid — varchar(50) — 기본 키 — NOT NULL
- aemail — varchar(100) — 기본 키 — NOT NULL
- atel — char(11) — 기본 키 — NOT NULL
- apass — text — NOT NULL
- aname — char(30) — NOT NULL
- adep — enum('임원','전산팀','디자인팀','CS팀','MD팀') — NOT NULL
- apost — enum('대표','부장','팀장','과장','대리','사원') — NOT NULL
- aroval — enum('승인','미승인') — NOT NULL
- adate — datetime — NOT NULL
admin_notice
- nidx — int(6) — 기본 키 — NOT NULL
- nprint — enum('Y','N') — NOT NULL
- nsubject — varchar(320) — NOT NULL
- nid — varchar(50) — NOT NULL
- nname — char(30) — NOT NULL
- nfile — text
- ncontent — text — NOT NULL
- ncount — int(8)
- ndate — datetime — NOT NULL
air_code
- airidx — int(6) — 기본 키 — NOT NULL
- airname — varchar(50) — 기본 키 — NOT NULL
- aircode — char(8) — 기본 키 — NOT NULL
- airplane — varchar(10) — NOT NULL
- airflight — char(40) — NOT NULL
- airuse — enum('Y','N')
- airdate — datetime — NOT NULL
air_plane
- pidx — int(8) — 기본 키 — NOT NULL
- airname (airname2) — varchar(50) — 외래 키 → air_code.airname — NOT NULL
- aircode (aircode2) — char(8) — 외래 키 → air_code.aircode — NOT NULL
- airplane — varchar(10)
- airname — varchar(50)
- aircode — char(8)
- air_flight — char(40)
- start_point — varchar(50)
- end_point — varchar(50)
- seat — char(30)
- seat_ea — int(3)
- air_use — enum('Y','N')
- resok — enum('Y','N')
- pdate — datetime
air_user
- uidx — int(8) — 기본 키 — NOT NULL
- utel — char(11) — 기본 키 — NOT NULL
- airplane — varchar(10) — NOT NULL
- airname — varchar(50) — NOT NULL
- aircode — char(8) — NOT NULL
- start_point — varchar(50) — NOT NULL
- end_point — varchar(50) — NOT NULL
- seat — char(30) — NOT NULL
- uname — varchar(50) — NOT NULL
- udate — datetime — NOT NULL
- uea — char(3) — NOT NULL
- uprice — char(10) — NOT NULL
faq
- fidx — int(8) — 기본 키 — NOT NULL
- fsubject — varchar(300) — NOT NULL
- fname — char(50) — NOT NULL
- fcontent — text — NOT NULL
- fdate — datetime — NOT NULL
info
- idx — int(6) — 기본 키 — NOT NULL
- isubject — varchar(100) — NOT NULL
- iemail — varchar(200) — NOT NULL
- ipoint_use — enum('Y','N') — NOT NULL
- ijoin_point — char(10) — NOT NULL
- ilevel — char(2) — NOT NULL
- icompany — varchar(200) — NOT NULL
- icode — char(12) — NOT NULL
- iname — char(50) — NOT NULL
- itel — char(11) — NOT NULL
- ireport_num — text — NOT NULL
- icom_code — text
- ipost — char(10) — NOT NULL
- iaddr — text — NOT NULL
- imanager_name — char(50) — NOT NULL
- imanager_email — varchar(300) — NOT NULL
- ibank — varchar(50) — NOT NULL
- ibank_num — varchar(20) — NOT NULL
- icard_use — enum('Y','N') — NOT NULL
- ihp_use — enum('Y','N') — NOT NULL
- ivou_use — enum('Y','N') — NOT NULL
- imin_point — char(10) — NOT NULL
- imax_point — char(10) — NOT NULL
- icash — enum('Y','N') — NOT NULL
- idate — datetime — NOT NULL
seat
- ridx — int(8) — 기본 키 — NOT NULL
- pidx (pidx2) — int(8) — 외래 키 → air_plane.pidx — NOT NULL
- pidx — int(8) — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- rprice — char(11) — NOT NULL
- rdate — datetime — NOT NULL