rerere
Tables (18)
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 — VARCHAR(100)
- business_url — VARCHAR(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 — VARCHAR(2)
- grade_name — VARCHAR(20) — NOT NULL
like
- like_id — VARCHAR2(200) — NOT NULL
- board_no — NUMBER — 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 — VARCHAR(2)
- term_name — VARCHAR(20) — NOT NULL
terms_agree
- terms_code — VARCHAR(2)
- id — VARCHAR2(20)
- agree_chk — VARCHAR(1) — NOT NULL
- agree_date — DATE — NOT NULL
user
- id — VARCHAR2(200)
- pw — VARCHAR2(500) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- nick — VARCHAR(200) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- birth — DATE — NOT NULL
- gender — VARCHAR(2) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- address — VARCHAR(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 — VARCHAR(2) — NOT NULL
- business_no — NUMBER