0504_erd_demo

Tables (9)

Untitled (TB_MEMBERS)

  • Key (mem_id) — VARCHAR2(1000) — Primary key — NOT NULL
  • Field (mem_pw) — VARCHAR2(1000)
  • Field2 (mem_name) — VARCHAR2(1000)
  • Field2 (mem_nickname) — VARCHAR2(1000)
  • Field (mem_gender) — VARCHAR2(1000)
  • Field3 (mem_mbti) — VARCHAR2(1000)
  • Field4 (mem_intro) — VARCHAR2(1000)
  • Field5 (mem_bir) — DATE
  • Field6 (mem_adrs) — VARCHAR2(1000)
  • Field7 (mem_hp) — VARCHAR2(1000)
  • Field8 (mem_mail) — VARCHAR2(1000)
  • Field9 (mem_hobby) — VARCHAR2(1000)
  • Field10 (mem_like) — VARCHAR2(1000)
  • Field11 (mem_del_yn) — VARCHAR2(1000)
  • Field (mem_join_date) — VARCHAR2(1000)

Untitled (TB_ATTACHES)

  • Key (atch_no) — NUMBER — Primary key — NOT NULL
  • Key (atch_reg_id) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Field2 (atch_parent_no) — VARCHAR2(1000)
  • Field (atch_category) — VARCHAR2(1000)
  • Field (atch_file_name) — VARCHAR2(1000)
  • Field (atch_original_name) — VARCHAR2(1000)
  • Field (atch_file_size) — NUMBER
  • Field (atch_convert_size) — VARCHAR2(1000)
  • Field (atch_content_type) — VARCHAR2(1000)
  • Field (atch_path) — VARCHAR2(1000)
  • Field (atch_del_yn) — VARCHAR2(1000)
  • Field2 (atch_reg_date) — DATE

Untitled (TB_BOARDS)

  • Key (b_num) — VARCHAR2(1000) — Primary key — NOT NULL
  • Key (b_member) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Key (b_img_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (b_pass) — VARCHAR2(1000)
  • Field (b_cate) — VARCHAR2(1000)
  • Field (b_title) — VARCHAR2(1000)
  • Field (b_content) — VARCHAR2(1000)
  • Field (b_recruit_bgn) — DATE
  • Field (b_recruit_end) — DATE
  • Field2 (b_location) — VARCHAR2(1000)
  • Field3 (b_min_age) — NUMBER
  • Field4 (b_max_age) — NUMBER
  • Field5 (b_day) — DATE
  • Field8 (b_wday) — DATE DEFAULT SYSDATE
  • Field9 (b_view_cnt) — NUMBER
  • Field (b_push_cnt) — NUMBER

Untitled (TB_REPLIES)

  • Key (b_num) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Key (r_member) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Field (r_num) — NUMBER
  • Field (r_content) — VARCHAR2(1000)
  • Field (r_reg_date) — DATE DEFAULT SYSDATE

Untitled (TB_CLUBS)

  • Key (c_name) — VARCHAR2(1000) — Primary key — NOT NULL
  • Key (c_image) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (c_owner) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Field (c_cate) — VARCHAR2(1000)
  • Field (c_cycle) — VARCHAR2(1000)
  • Field (c_history) — VARCHAR2(1000)
  • Field (c_intro) — VARCHAR2(1000)

Untitled (TB_club_role)

  • Key (mem_id) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Key (c_name) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Field (cr_role) — VARCHAR2(1000)
  • Field (cr_role_name) — VARCHAR2(1000)

Untitled (TB_MEM_RELATIONS)

  • Key (mem_id) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Field (relate_id) — VARCHAR2(1000)

Untitled (TB_QNA)

  • Field (question) — VARCHAR2(1000)
  • Field2 (answer) — VARCHAR2(1000)
  • Field (category) — VARCHAR2(1000)

Untitled2 (TB_MEMBER_STAT)

  • Key (mem_id) — VARCHAR2(1000) — Foreign key → Untitled.Key — NOT NULL
  • Field (mem_temp) — NUMBER DEFAULT 36.5
  • Field (mem_recom_cnt) — NUMBER
  • Field (mem_report_cnt) — NUMBER