portfolio
Tables (6)
admin
- midx — int(6) — Primary key — NOT NULL
- mid — varchar(6)
- mpass — text
- mname — char(50)
- memail — varchar(40)
- mhp — char(11)
- mselect1 — enum('임원','전산팀','디자인팀','CS팀','MD팀')
- mselect2 — enum('대표','부장','팀장','과장','대리','사원')
- mcheck — enum('Y','N')
- mdate — datetime
- mcount (mount) — int(6)
air_code
- aidx — int(7) — Primary key — NOT NULL
- aircode — char(6) — Primary key — NOT NULL
- airplane — char(10) — NOT NULL
- airname — varchar(40) — NOT NULL
- airflight — char(40) — NOT NULL
- airuse — enum('Y','N') — NOT NULL
- airdate — datetime — NOT NULL
faq
- fidx — int(6) — Primary key — NOT NULL
- ftitle — varchar(200) — NOT NULL
- fwriter — char(100) — NOT NULL
- ftext — text — NOT NULL
- fdate — datetime — NOT NULL
noticewrite
- midx — int(60) — Primary key — NOT NULL
- mcheck — tinyint(1) — NOT NULL
- mtitle — varchar(300) — NOT NULL
- mname — char(50) — NOT NULL
- mfile — text — NOT NULL
- mtext — text — NOT NULL
- mdate — datetime — NOT NULL
- file_name — varchar(100)
- mviews — int(5) — NOT NULL
paylist
- aidx — int(7) — Primary key — NOT NULL
- airplane — char(10) — NOT NULL
- airname — varchar(40) — NOT NULL
- aircode — char(6) — NOT NULL
- start_point — varchar(50) — NOT NULL
- end_point — varchar(50) — NOT NULL
- seat_text — varchar(6) — NOT NULL
- aname — varchar(50) — NOT NULL
- atel — varchar(11) — NOT NULL
- areserve — date — NOT NULL
- amember — int(3) — NOT NULL
- apay — int(8) — NOT NULL
- adate — datetime — NOT NULL
siteinfo
- sidx — int(6) — Primary key — NOT NULL
- stitle — varchar(200) — NOT NULL
- semail1 — varchar(40) — NOT NULL
- spoint1 — enum('Y','N') — NOT NULL
- sreward — int(6) — NOT NULL
- slevel — int(2) — NOT NULL
- scompany — varchar(200) — NOT NULL
- scompany_number — varchar(50) — NOT NULL
- sname — char(50) — NOT NULL
- stel — varchar(20) — NOT NULL
- snumber1 — varchar(20) — NOT NULL
- snumber2 — varchar(20)
- snumber3 — varchar(20) — NOT NULL
- saddress — varchar(200) — NOT NULL
- sname2 — char(50) — NOT NULL
- semail2 — varchar(40) — NOT NULL
- sbank — varchar(200) — NOT NULL
- snumber4 — varchar(50) — NOT NULL
- scard — enum('Y','N') — NOT NULL
- shp — enum('Y','N') — NOT NULL
- sgift — enum('Y','N') — NOT NULL
- spoint2 — int(6) — NOT NULL
- spoint3 — int(6) — NOT NULL
- sreceipt — enum('Y','N') — NOT NULL
- sdate — datetime — NOT NULL