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