모아임 최종

테이블 (7)

ADMIN (관리자)

  • Key (ID) — VARCHAR2(1000) — 기본 키 — NOT NULL
  • Field (PWD) — VARCHAR2(1000)
  • Field (NAME) — VARCHAR2(1000)
  • Field (PHONE) — VARCHAR2(1000)

BOARD (게시판)

  • Key (BSEQ) — NUMBER — 기본 키 — NOT NULL
  • Field (SUBJECT) — VARCHAR2(1000)
  • Field (CONTENT) — VARCHAR2(1000)
  • Key (ID) — VARCHAR2(1000) — 외래 키 → MEMBER.Key — NOT NULL
  • Field (CNT) — NUMBER
  • Field (INDATE) — DATE

CLUB (소모임)

  • Key (CSEQ) — NUMBER — 기본 키 — NOT NULL
  • Field (SUBJECT) — VARCHAR2(1000)
  • Field (CONTENT) — VARCHAR2(1000)
  • Key (ID) — VARCHAR2(1000) — 외래 키 → MEMBER.Key — NOT NULL
  • Field (INDATE) — DATE
  • Field (NUM) — NUMBER
  • Field (LIMIT) — NUMBER

COMMENTS (댓글)

  • Key (RSEQ) — NUMBER — 기본 키 — NOT NULL
  • Key (BSEQ) — NUMBER — 외래 키 → BOARD.Key — NOT NULL
  • Field (CONTENT) — VARCHAR2(1000)
  • Key (ID) — VARCHAR2(1000) — 외래 키 → MEMBER.Key — NOT NULL
  • Field (REGDATE) — DATE

FRIEND (소모임 회원)

  • Key (FSEQ) — NUMBER — 기본 키 — NOT NULL
  • Key (CSEQ) — NUMBER — 외래 키 → CLUB.Key — NOT NULL
  • Key (ID) — VARCHAR2(1000) — 외래 키 → MEMBER.Key — NOT NULL
  • Field (HOSTYN) — CHAR(1)
  • Field (BANYN) — CHAR(1)
  • Field (REGDATE) — DATE

MEMBER (회원)

  • Key (ID) — VARCHAR2(1000) — 기본 키 — NOT NULL
  • Field (PWD) — VARCHAR2(1000)
  • Field (NAME) — VARCHAR2(1000)
  • Field (EMAIL) — VARCHAR2(1000)
  • Field (PHONE) — VARCHAR2(1000)
  • Field (USEYN) — VARCHAR2(20)
  • Field (REGDATE) — DATE

QNA (문의게시판)

  • Key (QSEQ) — NUMBER — 기본 키 — NOT NULL
  • Field (SUBJECT) — VARCHAR2(1000)
  • Field (CONTENT) — VARCHAR2(1000)
  • Field (REPLY) — VARCHAR2(1000)
  • Key (ID) — VARCHAR2(1000) — 외래 키 → MEMBER.Key — NOT NULL
  • Field (REP) — CHAR(1)
  • Field (INDATE) — DATE