ㅇㅇㅇ

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