spring

Tables (4)

CHAT_MESSAGE (채팅방 메세지)

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

CHAT_ROOM (채팅방)

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

CHAT_ROOM_JOIN (채팅방조회)

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

Member (유저)

  • USER_NO (유저번호) — Number — Primary key — NOT NULL
  • USER_ID (유저 아이디) — VARCHAR2(110)
  • USER_PWD (유저 패스워드) — VARCHAR2(20)