모아임 최종
테이블 (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