spring

Tables (4)

CHAT_MESSAGE (Untitled3)

  • CM_NO (메세지번호) — Primary key — NOT NULL
  • MESSAGE (메세지내용)
  • CREATE_DATE (생성날짜)
  • CHAT_ROOM_NO (채팅방번호) — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
  • USER_NO (유저번호) — Number — Foreign key → Member.USER_NO — NOT NULL — dd

CHAT_ROOM (Untitled2)

  • CHAT_ROOM_NO (채팅방번호) — Primary key — NOT NULL
  • TITLE (제목)
  • STATUS (상태)
  • USER_NO (유저번호2) — Number — Foreign key → Member.USER_NO — NOT NULL — dd

CHAT_ROOM_JOIN (Untitled4)

  • USER_NO (유저번호) — Number — Foreign key → Member.USER_NO — NOT NULL — dd
  • CHAT_ROOM_NO (채팅방번호) — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL

Member (Untitled)

  • USER_NO (유저번호) — Number — Primary key — NOT NULL — dd
  • USER_ID (아이디) — varchar2(110)
  • USER_PWD (비밀번호) — VARCHAR2(20)