1024moimat
테이블 (15)
BOARD
- BRD_ID — NUMBER — 기본 키 — NOT NULL
- BRD_KEY — VARCHAR2(40 BYTE) — NOT NULL
- BRD_NAME — VARCHAR2(400 BYTE) — NOT NULL
- BRD_ORDER — NUMBER — NOT NULL
- BRD_USE — CHAR(1 BYTE) — NOT NULL
CERT
- CERT_ID — NUMBER — 기본 키 — NOT NULL
- CERT_CODE — VARCHAR2(40 BYTE) — NOT NULL
- CERT_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- CERT_REGDATE — DATE — NOT NULL
INTEREST
- INT_ID — NUMBER — 기본 키 — NOT NULL
- INT_KEY — VARCHAR2(40 BYTE) — NOT NULL
- INT_NAME — VARCHAR2(400 BYTE) — NOT NULL
- INT_ORDER — NUMBER — NOT NULL
- INT_USE — CHAR(1 BYTE) — NOT NULL
MEMBER
- MEM_ID — NUMBER — 기본 키 — NOT NULL
- MEM_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- MEM_PASSWORD — VARCHAR2(400 BYTE) — NOT NULL
- MEM_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- MEM_BIRTHDAY — DATE — NOT NULL
- MEM_GENDER — CHAR(1 BYTE) — NOT NULL
- AREA_ID — NUMBER — 외래 키 → 지역.AREA_ID — NOT NULL
- MEM_REGDATE — DATE — NOT NULL
- MEM_UPDATE — DATE — NOT NULL
- MEM_LASTLOGIN — DATE — NOT NULL
- MEM_CONTENT — VARCHAR2(400 BYTE)
- MEM_LEVEL — NUMBER — NOT NULL
- MEM_STATUS — NUMBER — NOT NULL
- MEM_INT1 — NUMBER — NOT NULL
- MEM_INT2 — NUMBER — NOT NULL
- MEM_INT3 — NUMBER — NOT NULL
- MEM_PHOTO — VARCHAR2(400 BYTE)
TEAM
- TEAM_ID — NUMBER — 기본 키 — NOT NULL
- INT_ID — NUMBER — 외래 키 → INTEREST.INT_ID — NOT NULL
- TEAM_NAME — VARCHAR2(40 BYTE) — NOT NULL
- TEAM_SHORT_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- TEAM_CONTENT — CLOB — NOT NULL
- AREA_ID — NUMBER — NOT NULL
- TEAM_REGDATE — DATE — NOT NULL
- TEAM_MAX — NUMBER — NOT NULL
- MEM_ID — NUMBER — 외래 키 → MEMBER.MEM_ID — NOT NULL
- TEAM_PHOTO — VARCHAR2(400 BYTE)
TEAM_CHAT
- CHAT_ID — NUMBER — 기본 키 — NOT NULL
- TEAM_ID — NUMBER — NOT NULL
- TMEM_ID — NUMBER — 외래 키 → TEAM_MEMBER.TMEM_ID — NOT NULL
- CHAT_CONTENT — VARCHAR2(400 BYTE) — NOT NULL
- CHAT_REGDATE — DATE — NOT NULL
TEAM_COMMENTS
- CMT_ID — NUMBER — 기본 키 — NOT NULL
- POST_ID — NUMBER — 외래 키 → TEAM_POST.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- CMT_NUM — NUMBER
- CMT_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- TMEM_ID — NUMBER — 외래 키 → TEAM_MEMBER.TMEM_ID — NOT NULL
- CMT_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- CMT_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- CMT_REGDATE — DATE — NOT NULL
- CMT_UPDATE — DATE — NOT NULL
- CMT_LIKE — NUMBER
- CMT_DISLIKE — NUMBER
TEAM_MEMBER
- TMEM_ID — NUMBER — 기본 키 — NOT NULL
- TEAM_ID — NUMBER — 외래 키 → TEAM.TEAM_ID — NOT NULL
- MEM_ID — NUMBER — NOT NULL
- TMEM_LEVEL — NUMBER — NOT NULL
- TMEM_CONTENT — VARCHAR2(4000 BYTE)
- TMEM_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- TMEM_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- TMEM_LASTVISIT — DATE — NOT NULL
- TMEM_REGDATE — DATE — NOT NULL
- TMEM_BIRTHDAY — DATE — NOT NULL
- TMEM_GENDER — CHAR(1 BYTE) — NOT NULL
- TMEM_PHOTO — VARCHAR2(400 BYTE)
TEAM_POST
- POST_ID — NUMBER — 기본 키 — NOT NULL
- POST_NUM — NUMBER
- TEAM_ID — NUMBER — 외래 키 → TEAM.TEAM_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- POST_TITLE — VARCHAR2(400 BYTE) — NOT NULL
- POST_CONTENT — CLOB — NOT NULL
- TMEM_ID — NUMBER — 외래 키 → TEAM_MEMBER.TMEM_ID — NOT NULL
- POST_TMEM_LEVEL — NUMBER — NOT NULL
- POST_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- POST_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- POST_REGDATE — DATE — NOT NULL
- POST_UPDATE — DATE — NOT NULL
- POST_HIT — NUMBER — NOT NULL
- POST_LIKE — NUMBER
- POST_DISLIKE — NUMBER
TEAM_POST_FILE
- PFI_ID — NUMBER — 기본 키 — NOT NULL
- POST_ID — NUMBER — 외래 키 → TEAM_POST.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- TMEM_ID — NUMBER — 외래 키 → TEAM_MEMBER.TMEM_ID — NOT NULL
- PFI_REGDATE — DATE — NOT NULL
- PFI_PHOTO — VARCHAR2(400 BYTE)
게시글 (POST)
- POST_ID — NUMBER — 기본 키 — NOT NULL
- POST_NUM — NUMBER
- BRD_ID — NUMBER — NOT NULL
- POST_TITLE — VARCHAR2(400 BYTE) — NOT NULL
- POST_CONTENT — CLOB — NOT NULL
- MEM_ID — NUMBER — 외래 키 → MEMBER.MEM_ID — NOT NULL
- POST_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- POST_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- POST_REGDATE — DATE — NOT NULL
- POST_UPDATE — DATE — NOT NULL
- POST_HIT — NUMBER — NOT NULL
- POST_REPLY — CHAR(1 BYTE)
- POST_ORIGIN — NUMBER
- POST_DEPTH — NUMBER
덧글 (COMMENTS)
- CMT_ID — NUMBER — 기본 키 — NOT NULL
- POST_ID — NUMBER — 외래 키 → 게시글.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- CMT_NUM — NUMBER
- CMT_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- MEM_ID — NUMBER — 외래 키 → MEMBER.MEM_ID — NOT NULL
- CMT_NICKNAME — VARCHAR2(400 BYTE) — NOT NULL
- CMT_EMAIL — VARCHAR2(400 BYTE) — NOT NULL
- CMT_REGDATE — DATE — NOT NULL
- CMT_UPDATE — DATE — NOT NULL
정모 (MEET)
- MEET_ID — NUMBER — 기본 키 — NOT NULL
- TEAM_ID — NUMBER — NOT NULL
- MEET_TITLE — VARCHAR2(400 BYTE) — NOT NULL
- MEET_CONTENT — CLOB — NOT NULL
- MEET_DATE — DATE — NOT NULL
- MEET_REGDATE — DATE — NOT NULL
- MEET_MAX — NUMBER — NOT NULL
- MEET_PAY — VARCHAR2(40 BYTE) — NOT NULL
- TMEM_ID — NUMBER — 외래 키 → TEAM_MEMBER.TMEM_ID — NOT NULL
- MEET_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- MEET_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- MEET_AREA — VARCHAR2(400 BYTE) — NOT NULL
- MEET_AREA_NAME — VARCHAR2(400 BYTE)
- MEET_PHOTO — CLOB
정모에 참여하는 회원 (MEET_MEMBER)
- MMEM_ID — NUMBER — 기본 키 — NOT NULL — PK;
- MEET_ID — NUMBER — 외래 키 → 정모.MEET_ID — NOT NULL
- TMEM_ID — NUMBER — 외래 키 → TEAM_MEMBER.TMEM_ID — NOT NULL
- MMEM_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- MMEM_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- MMEM_PHOTO — CLOB
지역 (AREA)
- AREA_ID — NUMBER — 기본 키 — NOT NULL
- AREA_KEY — VARCHAR2(40 BYTE) — NOT NULL
- AREA_NAME — VARCHAR2(40 BYTE) — NOT NULL
- AREA_REGION_KEY — VARCHAR2(40 BYTE) — NOT NULL
- AREA_REGION_NAME — VARCHAR2(40 BYTE) — NOT NULL