pot-0
테이블 (11)
BOARDS
- b_id — VARCHAR2(15 BYTE) — 외래 키 → stmembers.mem_id
- b_number — NUMBER(5)
- b_title — VARCHAR2(80 BYTE)
- b_content — VARCHAR2(3000 BYTE)
- b_startdate — VARCHAR2(10 BYTE)
- b_finishdate — VARCHAR2(10 BYTE)
- b_stmember — NUMBER(5)
- b_interests — VARCHAR2(30 BYTE)
- b_goal — VARCHAR2(30 BYTE)
- b_status — NUMBER(5)
- b_ref — NUMBER(5)
- b_step — NUMBER(5)
- b_group — NUMBER(5)
- B_AREA — VARCHAR2
- B_LANGUAGE — VARCHAR2
groupboard
- gr_mem_gnum — NUMBER(5) — 외래 키 → groupmemberboard.gr_mem_gnum
- gr_mem_number — NUMBER(10)
- gr_mem_name — VARCHAR2(12 BYTE)
- gr_mem_study — VARCHAR2(2000 BYTE)
- gr_mem_conid — NUMBER(3)
- gr_mem_date — VARCHAR2(30 BYTE)
- gr_check — NUMBER(3)
groupmemberboard
- gr_mem_gnum — NUMBER(5) — 기본 키
- mem_id — VARCHAR2(15 BYTE) — 외래 키 → stmembers.mem_id
- gr_mem_number — NUMBER(10)
- gr_mem_name — VARCHAR2(12 BYTE)
- mem_email — VARCHAR2(50 BYTE)
- group_goal — VARCHAR2(2000 BYTE)
- group_studydate — VARCHAR2(30 BYTE)
- group_startdate — VARCHAR2(30 BYTE)
- group_finishdate — VARCHAR2(30 BYTE)
- group_interests — VARCHAR2(30 BYTE)
- group_report — NUMBER(3)
- group_like — NUMBER(3)
- gr_mem_date — VARCHAR2(20 BYTE)
- group_introduce — VARCHAR2(2000 BYTE)
grouprequest
- mem_id — VARCHAR2(15 BYTE)
- b_title — VARCHAR2(80 BYTE)
- b_id — VARCHAR2(15 BYTE)
- b_gmember — NUMBER(5)
- b_group — NUMBER(5)
- mem_name — VARCHAR2(15) — 외래 키 → groupboard.gr_mem_gnum
memtemp
- mem_id (mem_id2) — VARCHAR2(15 BYTE) — 외래 키 → 가입요청.mem_id
- gr_mem_gnum — NUMBER(5)
- gr_mem_number — NUMBER(10)
- group_like — NUMBER(3)
- gr_mem_date — VARCHAR2(20 BYTE)
- group_startdate — VARCHAR2(30 BYTE) — 외래 키 → BOARDS.b_id
- group_finishdate — VARCHAR2(30 BYTE) — 외래 키 → BOARDS.b_id
- group_interests — VARCHAR2(30 BYTE) — 외래 키 → BOARDS.b_id
- group_goal — VARCHAR2(2000 BYTE) — 외래 키 → BOARDS.b_id
- mem_email — VARCHAR2(50 BYTE) — 외래 키 → stmembers.mem_id
- group_ntroduce (group_introduce) — VARCHAR2(2000 BYTE) — 외래 키 → stmembers.mem_id
- group_name — VARCHAR2(15 BYTE) — 외래 키 → stmembers.mem_id
- group_report — NUMBER_(5) — 외래 키 → stmembers.mem_id
stmembers
- mem_id — VARCHAR2(15 BYTE) — 기본 키
- mem_num — NUMBER
- mem_pw — VARCHAR2(20 BYTE)
- mem_name — VARCHAR2(12 BYTE)
- mem_jumin — NUMBER(13)
- mem_tel — NUMBER(11)
- mem_email — VARCHAR2(50 BYTE)
- mem_interests — VARCHAR2(30 BYTE)
- mem_introduce — VARCHAR2(2000 BYTE)
- mem_report — NUMBER(5)
가입요청 (Untitled3)
- mem_id — VARCHAR2(15 BYTE) — 외래 키 → groupmemberboard.mem_id
게시글 (Untitled2)
- b_interests — VARCHAR2(30 BYTE) — 외래 키 → BOARDS.b_id
- b_language — VARCHAR2 — 외래 키 → BOARDS.b_id
- b_id — varchar2(15) — 외래 키 → groupboard.gr_mem_gnum
내가 작성한 글 (write)
- b_interests — VARCHAR2(30 BYTE) — 외래 키 → BOARDS.b_id
- b_language — VARCHAR2 — 외래 키 → BOARDS.b_id
- b_id — varchar2(15) — 외래 키 → groupboard.gr_mem_gnum
- gr_mem_gnum — NUMBER(5) — 외래 키 → groupmemberboard.gr_mem_gnum
로그인 (Untitled)
- mem_id — VARCHAR2(15 BYTE) — 외래 키 → stmembers.mem_id
- mem_pw — varchar2(20)
프로필 (profile)
- mem_id (mem_id2) — VARCHAR2(15 BYTE) — 외래 키 → stmembers.mem_id
- mem_num — NUMBER
- mem_pw — VARCHAR2(20 BYTE)
- mem_name — VARCHAR2(12 BYTE)
- mem_jumin — NUMBER(13)
- mem_tel — NUMBER(11)
- mem_email — VARCHAR2(50 BYTE)
- mem_interests — VARCHAR2(30 BYTE)
- mem_introduce — VARCHAR2(2000 BYTE)
- mem_report — NUMBER(5)