naver cafe
Tables (18)
Untitled
- cafe_question_num — number(5) — Primary key — NOT NULL
- cafe_id — varchar2(100) — NOT NULL
- cafe_question_content — varchar2(200)
Untitled2
- cafe_answer_num — number(5) — Primary key — NOT NULL
- cafe_question_num — number(5) — Foreign key → Untitled.cafe_question_num — NOT NULL
- user_id — varchar2(100) — NOT NULL
- cafe_answer_content — varchar2(200)
proejct_cafe_deported
- Key — VARCHAR(255) — Primary key — NOT NULL
- user_id — varchar2(20) — NOT NULL
- deported_reason — varchar2(100)
- regDate — Date — NOT NULL
project_blacklist
- cafe_id — varchar2(20) — Primary key — NOT NULL
- user_id — varchar2(20) — Primary key — NOT NULL
- blacklist_regDate — Date
- reason — varchar2(100)
project_board
- board_num — number(6) — Primary key — NOT NULL
- board_title — varchar2(200)
- board_content — clob
- board_savedate — Date
- board_likes — number(5)
- board_notice — char(2)
- board_reply_allow — char(2)
- board_prefix — varchar2(20)
- user_id — varchar2(20) — NOT NULL
- board_menu_num — number(6)
- hit — number(6)
project_boardType
- board_menu_num — number(6) — Primary key — NOT NULL — 게시판고유번호(시퀀스)
- board_menu_desc — varchar2(200)
- board_write_auth — number(2)
- board_reply_auth — number(2)
- board_read_auth — number(2)
- board_menu_name — varchar2(200) — NOT NULL
- cafe_id — varchar2(20)
- board_order — number(5)
- board_menu_type — number(2) — NOT NULL
project_cafe_info
- cafe_id — varchar2(100) — Primary key — NOT NULL
- cafe_name — varchar2(200) — NOT NULL
- cafe_explanation — varchar2(5000)
- cafe_title_num — number(5)
- cafe_front — clob
- cafe_skin — varchar2(200)
- cafe_layout — varchar2(200)
- user_id — varchar2(20)
- cafe_join_apply — char(1) — NOT NULL
project_cafe_join_request
- cafe_request_num — number(5) — Primary key — NOT NULL
- cafe_id — varchar2(100) — NOT NULL
- user_id — varchar2(20) — NOT NULL
- Field — date — NOT NULL
project_cafe_member
- cafe_id — varchar2(100) — Primary key — NOT NULL
- cafe_user_nickname — varchar2(100) — NOT NULL
- cafe_user_image_num — number
- cafe_user_grade — number — NOT NULL
- cafe_user_visit — number
- cafe_user_write — number
- cafe_user_reply — number
- cafe_user_visit_check — number
- cafe_user_regdate — date
- cafe_user_applydate — date
- cafe_user_status — char(1)
- cafE_user_email_receieve — char(1)
- cafe_user_gender_reveal — char(1)
project_file
- file_num — number(5) — Primary key — NOT NULL
- file_directory — varchar2(200)
- file_org_name — varchar2(500)
- file_stored_name — varchar2(500)
- regdate — date
- board_num — number(5)
- cafe_title_num — number(5)
- reply_num — number(5)
- cafe_user_image_num — number(5)
project_likes
- board_num — number(6) — Primary key — NOT NULL
- user_id — varchar2(20) — Primary key — NOT NULL
project_member_grade
- cafe_id — varchar2(20) — Primary key — NOT NULL
- cafe_user_grade — number — Primary key — NOT NULL
- cut_visit — number(4)
- cut_reply — number(4)
- cut_board — number(4)
- cut_desc — varchar2(100) — NOT NULL
- cut_name — varchar2(20) — NOT NULL
- cut_type — number(1)
- cut_removed — varchar2(15)
project_members
- user_id — varchar2(20) — Primary key — NOT NULL
- user_pw — varchar2(100) — NOT NULL
- user_name — varchar2(20)
- user_phone — varchar2(20)
- user_email — varchar2(20)
- user_postalcode — varchar2(20)
- user_addr — varchar2(50)
- user_detail_addr — varchar2(20)
- user_regDate — Date
- user_point — number(5)
- user_level — number(2)
- user_gender — char(1)
- user_birthdate — date
project_memo_board
- memo_num — number(6) — Primary key — NOT NULL
- user_id — varchar2(20) — NOT NULL
- memo_content — varchar2(500) — NOT NULL
- memo_saveDate — Date
- memo_step_only — char(2)
- Field — VARCHAR(255)
project_memo_reply
- memo_reply_num — number(6) — Primary key — NOT NULL
- user_id — varchar2(20) — NOT NULL
- memo_reply_content — varchar2(100) — NOT NULL
- memo_reply_saveDate — Date
- memo_reply_image_name — varchar2(200)
project_prefixes
- prefix_num — number(6) — Primary key — NOT NULL
- prefix_name — varchar2(15)
- board_menu_num — number(6) — NOT NULL
project_reply
- reply_num — number(6)
- board_num — number(6)
- reply_content — varchar2(500)
- reply_saveDate — Date
- user_id — varchar2(20) — NOT NULL
project_upgrade_board
- user_id — varchar2(20) — Primary key — NOT NULL
- grade_up — varchar2(20)
- grade_now — varchar2(20)
- cafe_user_visit — number(5)
- cafe_user_write — number(5)
- cafe_user_reply — number(5)
- cafe_user_regdate — date
- apply_date — date