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