moimAt
Tables (19)
AREA
- AREA_ID — NUMBER — Primary key — 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
BOARD
- BRD_ID — NUMBER — Primary key — 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 — Primary key — NOT NULL
- CERT_CODE — VARCHAR2(40 BYTE) — NOT NULL
- CERT_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- CERT_REGDATE — DATE — NOT NULL
COMMENTS
- CMT_ID — NUMBER — Primary key — NOT NULL
- POST_ID — NUMBER — Foreign key → POST.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- CMT_NUM — NUMBER
- CMT_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- MEM_ID — NUMBER — Foreign key → 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
INTEREST
- INT_ID — NUMBER — Primary key — 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
MEET
- MEET_ID — NUMBER — Primary key — 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 — Foreign key → 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_PHOTO — VARCHAR2(4000 BYTE) — NOT NULL
- MEET_AREA_NAME — VARCHAR2(400 BYTE)
MEET_MEMBER
- MMEM_ID — NUMBER — Primary key — NOT NULL — PK;
- MEET_ID — NUMBER — Foreign key → MEET.MEET_ID — NOT NULL
- TMEM_ID — NUMBER — Foreign key → TEAM_MEMBER.TMEM_ID — NOT NULL
- MMEM_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- MMEM_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- MMEM_PHOTO — VARCHAR2(400 BYTE) — NOT NULL
MEMBER
- MEM_ID — NUMBER — Primary key — 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 — Foreign key → AREA.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_PHOTO — 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
MESSAGE
- MSG_ID — NUMBER — Primary key — NOT NULL
- SEND_MEM_ID — NUMBER — Foreign key → MEMBER.MEM_ID — NOT NULL
- RECV_MEM_ID — NUMBER — NOT NULL
- MSG_TITLE — VARCHAR2(400 BYTE) — NOT NULL
- MSG_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- MSG_REGDATE — DATE — NOT NULL
- MSG_READDATE — DATE
POST
- POST_ID — NUMBER — Primary key — 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 — Foreign key → 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
POST_FILE
- PFI_ID — NUMBER — Primary key — NOT NULL
- POST_ID — NUMBER — Foreign key → POST.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- MEM_ID — NUMBER — Foreign key → MEMBER.MEM_ID — NOT NULL
- PFI_ORIGINNAME — VARCHAR2(4000 BYTE) — NOT NULL
- PFI_FILENAME — VARCHAR2(4000 BYTE) — NOT NULL
- PFI_FILESIZE — NUMBER
- PFI_WIDTH — NUMBER
- PFI_HEIGHT — NUMBER
- PFI_TYPE — VARCHAR2(10 BYTE)
- PFI_IS_IMAGE — NUMBER
- PFI_REGDATE — DATE — NOT NULL
SNS_INFO
- MEM_ID — NUMBER — Foreign key → MEMBER.MEM_ID — NOT NULL — member
- SNS_ID — VARCHAR2(400 BYTE) — NOT NULL
- SNS_TYPE — VARCHAR2(40 BYTE)
- SNS_NAME — VARCHAR2(400 BYTE)
- SNS_PROFILE — VARCHAR2(400 BYTE)
- SNS_CONNECT_DATE — DATE
TEAM
- TEAM_ID — NUMBER — Primary key — NOT NULL
- INT_ID — NUMBER — Foreign key → 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 — Foreign key → MEMBER.MEM_ID — NOT NULL
- TEAM_PHOTO — VARCHAR2(40 BYTE)
TEAM_CHAT
- CHAT_ID — NUMBER — Primary key — NOT NULL
- TEAM_ID — NUMBER — NOT NULL
- TMEM_ID — NUMBER — Foreign key → TEAM_MEMBER.TMEM_ID — NOT NULL
- CHAT_CONTENT — VARCHAR2(400 BYTE) — NOT NULL
- CHAT_REGDATE — DATE — NOT NULL
TEAM_COMMENTS
- CMT_ID — NUMBER — Primary key — NOT NULL
- POST_ID — NUMBER — Foreign key → TEAM_POST.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- CMT_NUM — NUMBER
- CMT_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- TMEM_ID — NUMBER — Foreign key → 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 — Primary key — NOT NULL
- TEAM_ID — NUMBER — Foreign key → TEAM.TEAM_ID — NOT NULL
- MEM_ID — NUMBER — NOT NULL
- TMEM_LEVEL — NUMBER — NOT NULL
- TMEM_CONTENT — VARCHAR2(4000 BYTE) — NOT NULL
- 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_NOTE
- TNO_ID — NUMBER — Primary key — NOT NULL
- TEAM_ID — NUMBER — NOT NULL
- TNO_CONTENT — VARCHAR2(400 BYTE) — NOT NULL
- TMEM_ID — NUMBER — Foreign key → TEAM_MEMBER.TMEM_ID — NOT NULL
- TNO_NICKNAME — VARCHAR2(40 BYTE) — NOT NULL
- TNO_EMAIL — VARCHAR2(40 BYTE) — NOT NULL
- TNO_REGDATE — DATE — NOT NULL
TEAM_POST
- POST_ID — NUMBER — Primary key — NOT NULL
- POST_NUM — NUMBER
- TEAM_ID — NUMBER — Foreign key → 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 — Foreign key → 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 — Primary key — NOT NULL
- POST_ID — NUMBER — Foreign key → TEAM_POST.POST_ID — NOT NULL
- BRD_ID — NUMBER — NOT NULL
- TMEM_ID — NUMBER — Foreign key → TEAM_MEMBER.TMEM_ID — NOT NULL
- PFI_ORIGINNAME — VARCHAR2(4000 BYTE) — NOT NULL
- PFI_FILENAME — VARCHAR2(4000 BYTE) — NOT NULL
- PFI_FILESIZE — NUMBER
- PFI_WIDTH — NUMBER
- PFI_HEIGHT — NUMBER
- PFI_TYPE — VARCHAR2(10 BYTE)
- PFI_IS_IMAGE — NUMBER
- PFI_REGDATE — DATE — NOT NULL