ㅁㅇㅁㅇ
Tables (7)
board
- b_no — number — Primary key — NOT NULL — 시퀀스(auto
- b_title — varchar2(100) — NOT NULL
- b_nick — varchar2(30) — NOT NULL — 한글로는
- b_content — varchar2(500) — NOT NULL
- b_date — date — NOT NULL
- b_click — number — NOT NULL
- b_cate — number — NOT NULL
cafe
- c_no — number — Primary key — NOT NULL — 시퀀스(auto
- c_name — varchar2(50) — Primary key — NOT NULL — 외래키
- c_tel — varchar2(20) — NOT NULL
- c_bhours — varchar2(20) — NOT NULL
- c_address — varchar2(200) — NOT NULL
- c_domain — varchar2(100) — NOT NULL
- c_loc — varchar2(20) — NOT NULL
reply
- reply_no — number — Primary key — NOT NULL — 시퀀스(auto
- reply_bno — number — NOT NULL — 글no
- nick — varchar2(30) — NOT NULL — 유저
- reply_date — date — NOT NULL
- reply_content — varchar2(300) — NOT NULL
- reply_dept — number — NOT NULL
- reply_level — number — NOT NULL
reserve
- no — number — Primary key — NOT NULL — 시퀀스(auto
- r_date — varchar2(100) — NOT NULL — 방탈출
- r_loc — varchar2(20) — NOT NULL
- r_cafe — varchar2(50) — NOT NULL
- r_theme — varchar2(50) — NOT NULL
- r_time — varchar2(20) — NOT NULL
- r_player — number — NOT NULL
- r_money — number — NOT NULL
- r_comment — varchar2(100) — 메모는
- r_payment — varchar2(20) — 예약할
- email — varchar2(50) — NOT NULL — 이메일이
- Field — VARCHAR(255)
review
- no — number — Primary key — NOT NULL — 시퀀스(auto
- review_tno — number — NOT NULL — 시퀀스(auto
- nick — varchar2(30) — NOT NULL — 닉네임
- review_playdate — varchar2(50) — NOT NULL
- review_rating — number — NOT NULL — 평점은
- review_difficult — number — 널허용
- review_clear — varchar2(1) — NOT NULL
- review_time — varchar2(20) — 널허용
- review_hint — number — 널허용
- review_content — varchar2(300) — NOT NULL
- review_date — date — NOT NULL
theme
- t_no — number — Primary key — NOT NULL — 시퀀스(auto
- rating — number — 평점은
- t_name — varchar2(50) — NOT NULL
- c_name — varchar2(50) — NOT NULL — 외래키
- genre — varchar2(20) — NOT NULL
- activity — number — NOT NULL
- difficult — number — NOT NULL
- limit — number — NOT NULL
- recommend — number — NOT NULL — ex)
- intro — varchar2(500) — NOT NULL
- image_loc — varchar2(300) — NOT NULL
user
- u_no — number — Primary key — NOT NULL — 시퀀스(auto
- email — varchar2(50) — Primary key — NOT NULL — 이메일이
- nick — varchar2(30) — Primary key — NOT NULL — 한글로는
- phone — varchar2(20) — NOT NULL
- password — varchar2(20) — NOT NULL
- regdate — date — NOT NULL
- status — number — NOT NULL — 1