spring
Tables (4)
CHAT_MESSAGE (Untitled3)
- CHAT_MESSAGE (메시지번호) — NUMBER — Primary key — NOT NULL
- MESSAGE (메시지내용) — VARCHAR
- 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 (Untitled2)
- CHAT_ROOM_NO (채팅방번호) — NUMBER — Primary key — NOT NULL
- TITLE (제목) — VARCHAR2(200)
- STATUS (상태) — CHAR(1)
- USER_NO (유저번호) — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL — 유저번호
CHAT_ROOM_JOIN (Untitled4)
- USER_NO (유저번호) — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL — 유저번호
- CHAT_ROOM_NO (채팅방번호) — NUMBER — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
MEMBER (Untitled)
- USER_NO (유저번호) — NUMBER — Primary key — NOT NULL — 유저번호
- USER_ID (아이디) — VARCHAR2(30)
- USER_PWD (비밀번호) — VARCHAR2(100)
- USER_NAME (이름) — VARCHAR2(15)
- EMAIL (Field)