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