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)