dd

Tables (17)

admin

  • admin_id — VARCHAR2(200) — NOT NULL
  • admin_pw — VARCHAR2(500) — NOT NULL

board

  • board_no — NUMBER
  • menu_no — VARCHAR2(2) — NOT NULL
  • cate_no — VARCHAR2(2) — NOT NULL
  • board_addr — VARCHAR2(100) — NOT NULL
  • writer_id — VARCHAR2(100) — NOT NULL
  • write_date — DATE — NOT NULL
  • hit — NUMBER
  • title — VARCHAR2(500) — NOT NULL
  • price — NUMBER — NOT NULL
  • content — VARCHAR2(4000)

booking

  • book_no — NUMBER
  • board_no — NUMBER
  • booker_id — VARCHAR2(200) — NOT NULL
  • book_date — DATE — NOT NULL

business

  • business_no — NUMBER
  • business_name — VARCHAR2(50)
  • business_phone — VARCHAR2(20)
  • business_addr — VARCHAR2(100)
  • business_url — VARCHAR2(100)

category

  • cate_no — VARCHAR2(2) — NOT NULL
  • cate_name — VARCHAR2(100) — NOT NULL
  • cate_kind — VARCHAR2(1) — NOT NULL

comment

  • cmt_no — NUMBER
  • menu_no — VARCHAR2(2) — NOT NULL
  • writing_no — NUMBER — NOT NULL
  • write_date — DATE — NOT NULL
  • writer_id — VARCHAR2(100) — NOT NULL
  • content — VARCHAR2(1000)

community

  • commu_no — NUMBER
  • menu_no — VARCHAR2(2) — NOT NULL
  • cate_no — VARCHAR2(2) — NOT NULL
  • write_date — DATE — NOT NULL
  • writer_id — VARCHAR2(100) — NOT NULL
  • hit — NUMBER
  • title — VARCHAR2(500) — NOT NULL
  • content — VARCHAR2(4000)
  • commu_notice — VARCHAR2(1)

file

  • file_no — NUMBER
  • menu_no — VARCHAR2(2) — NOT NULL
  • board_no — NUMBER — NOT NULL
  • origin_name — VARCHAR2(500) — NOT NULL
  • stored_name — VARCHAR2(500) — NOT NULL
  • file_type — VARCHAR2(20) — NOT NULL

grade

  • grade_no — VARCHAR2(2)
  • grade_name — VARCHAR2(20) — NOT NULL

menu

  • menu_no — VARCHAR2(2) — NOT NULL
  • menu_name — VARCHAR2(20) — NOT NULL

report

  • report_no — NUMBER
  • report_id — VARCHAR2(200) — NOT NULL
  • report_type — VARCHAR2(2) — NOT NULL
  • report_date — DATE — NOT NULL
  • menu_no — VARCHAR2(2) — NOT NULL
  • writing_no — NUMBER — NOT NULL
  • cmt_no — NUMBER — NOT NULL

report_info

  • report_type — VARCHAR2(2)
  • report_name — VARCHAR2(50) — NOT NULL

terms

  • terms_code — VARCHAR2(2)
  • term_name — VARCHAR2(20) — NOT NULL

terms_agree

  • terms_code — VARCHAR2(2)
  • id — VARCHAR2(20)
  • agree_chk — VARCHAR2(1) — NOT NULL
  • agree_date — DATE — NOT NULL

user

  • id — VARCHAR2(200)
  • pw — VARCHAR2(500) — NOT NULL
  • name — VARCHAR2(20) — NOT NULL
  • nick — VARCHAR2(200) — NOT NULL
  • email — VARCHAR2(50) — NOT NULL
  • birth — DATE — NOT NULL
  • gender — VARCHAR2(2) — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • address — VARCHAR2(100) — NOT NULL

user_log

  • id — VARCHAR2(20)
  • join_date — DATE — NOT NULL
  • pw_update — DATE — NOT NULL
  • grade_update — DATE — NOT NULL
  • access_date — DATE — NOT NULL
  • access_cnt — NUMBER — NOT NULL
  • book_cnt — NUMBER
  • rent_cnt — NUMBER

user_page

  • id — VARCHAR2(20)
  • file_no — NUMBER
  • intro — VARCHAR2(500)
  • grade_no — VARCHAR2(2) — NOT NULL
  • business_no — NUMBER