kh
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
CHAT_ROOM (Untitled2)
- CHAT_ROOM_NO (채팅방번호) — Primary key — NOT NULL
- TITLE (제목)
- STATUS (Field2)
- USER_NO (유저번호2) — NUMBER — Foreign key → Member.USER_NO — NOT NULL
CHAT_ROOM_JOIN (Untitled4)
- Key — Primary key — NOT NULL
- USER_NO (유저번호) — NUMBER — Foreign key → Member.USER_NO — NOT NULL
- CHAT_ROOM_NO (채팅방번호) — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- Field
Member (Untitled)
- USER_NO (유저번호) — NUMBER — Primary key — NOT NULL
- USER_ID (아이디) — varchar2
- USER_PWD (비밀번호) — VARCHAR2(100 BYTE)