campingWeb
Tables (17)
QnA
- quno — int — Primary key — NOT NULL
- qutitle — varchar(50) — NOT NULL
- qucontent — text — NOT NULL
- qurdate — timestamp — NOT NULL
- quhit — int — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
QnA_reply
- qurno — int — Primary key — NOT NULL
- qurcontent — text — NOT NULL
- qurdate — timestamp — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
- quno — int — Foreign key → QnA.quno — NOT NULL
QnA_uploadfile
- qufno — int — Primary key — NOT NULL
- qufrealNm — varchar(255) — NOT NULL
- quforiginNm — varchar(255) — NOT NULL
- qufrdate — timestamp — NOT NULL
- quno — int — Foreign key → QnA.quno — NOT NULL
attendcheck_reply
- chrno — int — Primary key — NOT NULL
- chrcontent — text — NOT NULL
- chrdate — timestamp — NOT NULL
- chno — int — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
free
- frno — int — Primary key — NOT NULL
- frtitle — varchar(50) — NOT NULL
- frcontent — text — NOT NULL
- frdate — timestamp — NOT NULL
- frhit — int — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
free_reply
- frrno — int — Primary key — NOT NULL
- frrcontent — text — NOT NULL
- frrdate — timestamp — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
- frno — int — Foreign key → free.frno — NOT NULL
free_uploadfile
- frfno — int — Primary key — NOT NULL
- frfrealNm — varchar(255) — NOT NULL
- frforignNm — varchar(255) — NOT NULL
- frfrdate — timestamp — NOT NULL
- frno — int — Foreign key → free.frno — NOT NULL
gear
- grno — int — Primary key — NOT NULL
- grtitle — varchar(50) — NOT NULL
- grcontent — text — NOT NULL
- grrdate — timestamp — NOT NULL
- grhit — int — NOT NULL
- grtype — varchar(20) — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
gear_reply
- grrno — int — Primary key — NOT NULL
- grcontent — text — NOT NULL
- grrdate — timestamp — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
- grno — int — Foreign key → gear.grno — NOT NULL
gear_uploadfile
- grfno — int — Primary key — NOT NULL
- grfrealNm — varchar(255) — NOT NULL
- grforiginNm — varchar(255) — NOT NULL
- grrdate — timestamp
- grno — int — Foreign key → gear.grno — NOT NULL
member
- mno — int — Primary key — NOT NULL
- mid — varchar(50) — NOT NULL
- mpw — varchar(50) — NOT NULL
- mnickNm — varchar(20) — NOT NULL
- mname — varchar(20) — NOT NULL
- mbirth — int(8) — NOT NULL
- mphone — varchar(13) — NOT NULL
- mgender — char(1) — NOT NULL
- memail — varchar(50) — NOT NULL
- mrdate — timestamp — NOT NULL
notice
- nono — int — Primary key — NOT NULL
- notitle — varchar(50) — NOT NULL
- nocontent — text — NOT NULL
- nordate — timestamp — NOT NULL
- nohit — int — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
notice_reply
- norno — int — Primary key — NOT NULL
- norcontent — text — NOT NULL
- nordate — timestamp — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
- nono — int — Foreign key → notice.nono — NOT NULL
notice_uploadfile
- nofno — int — Primary key — NOT NULL
- nofrealNm — varchar(255) — NOT NULL
- noforiginNm — varchar(255) — NOT NULL
- nofrdate — timestamp — NOT NULL
- nono — int — Foreign key → notice.nono — NOT NULL
zone
- znno — int — Primary key — NOT NULL
- zntitle — varchar(50) — NOT NULL
- zncontent — text — NOT NULL
- znrdate — timestamp — NOT NULL
- znhit — int — NOT NULL
- zntype — varchar(20) — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
zone_reply
- znrno — int — Primary key — NOT NULL
- znrcontent — text — NOT NULL
- znrdate — timestamp — NOT NULL
- mno — int — Foreign key → member.mno — NOT NULL
- znno — int — Foreign key → zone.znno — NOT NULL
zone_uploadfile
- znfno — int — Primary key — NOT NULL
- znfrealNm — varchar(255) — NOT NULL
- znforiginNm — varchar(255) — NOT NULL
- znfrdate — timestamp — NOT NULL
- znno — int — Foreign key → zone.znno — NOT NULL