mia ERD
Tables (8)
CHAT_MESSAGE
- CHAT_NO — NUMBER — Primary key — NOT NULL — 채팅
- CHAT_CONTENT — VARCHAR2(4000) — NOT NULL
- CHAT_CREATE_DT — TIMESTAMP — NOT NULL
- CHAT_READ_YN — CHAR(1) — NOT NULL
- CHAT_ROOM_NO — NUMBER — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- MEMBER_NO — NUMBER — Foreign key → CHAT_ROOM.MEMBER_NO — NOT NULL
CHAT_ROOM
- CHAT_ROOM_NO — NUMBER — Primary key — NOT NULL
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
FREE_BOARD
- FREE_NO — NUMBER — Primary key — NOT NULL — 자유게시판
- FREE_TITLE — VARCHAR2(200) — NOT NULL
- FREE_CONTENT — VARCHAR2(4000) — NOT NULL
- FREE_READ_COUNT — NUMBER — NOT NULL
- FREE_STATUS — CHAR(1) — NOT NULL
- FREE_CREATE_DT — TIMESTAMP — NOT NULL
- FREE_MODIFY_DT — TIMESTAMP — NOT NULL
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
- FREE_CATEGORY_NO — NUMBER — Foreign key → FREE_CATEGORY.FREE_CATEGORY_NO — NOT NULL
FREE_CATEGORY
- FREE_CATEGORY_NO — NUMBER — Primary key — NOT NULL — 자유게시판
- FREE_CATEGORY_NM — VARCHAR2(100) — NOT NULL
FREE_IMAGE
- FILE_NO — NUMBER — Primary key — NOT NULL — 자유게시판
- FILE_NM — VARCHAR2(500) — NOT NULL
- FILE_PATH — VARCHAR2(100) — NOT NULL
- FREE_NO — NUMBER — Foreign key → FREE_BOARD.FREE_NO — NOT NULL
FREE_LIKE
- FREE_NO — NUMBER — Foreign key → FREE_BOARD.FREE_NO — NOT NULL — 자유게시판
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
FREE_REPLY
- FREE_REPLY_NO — NUMBER — Primary key — NOT NULL — 자유게시판
- FREE_REPLY_CONTENT — VARCHAR2(2000) — NOT NULL
- FREE_REPLY_CREATE_DT — TIMESTAMP — NOT NULL
- FREE_REPLY_STATUS — CHAR(1) — NOT NULL
- FREE_NO — NUMBER — Foreign key → FREE_BOARD.FREE_NO — NOT NULL
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
- PARENT_REPLY_NO — NUMBER — Foreign key → FREE_REPLY.FREE_REPLY_NO
MEMBER
- MEMBER_NO — NUMBER — Primary key — NOT NULL — 회원번호;
- MEMBER_ID — VARCHAR2(50) — NOT NULL
- MEMBER_PW — VARCHAR2(200) — NOT NULL
- MEMBER_NICK — VARCHAR2(30) — NOT NULL
- MEMBER_EMAIL — VARCHAR2(100) — NOT NULL
- MEMBER_PHONE — CHAR(13) — NOT NULL
- ENROLL_DATE — DATE — NOT NULL
- MEMBER_STATUS — CHAR(1) — NOT NULL
- MEMBER_GRADE — CHAR(1) — NOT NULL