MultiChattingDB
Tables (4)
ACTIONTABLE (Untitled2)
- USER_ID (아이디) — VARCHAR(20) — Foreign key → USERTABLE.USER_ID — NOT NULL — PRIMERY KEY
- ACTION_STATE (로그인상태) — VARCHAR(1) — NOT NULL — DEFAULT 'N'
- ACTION_LAST_UPDATE (최근 접속 날짜) — DATE — NOT NULL — DEFAULT SYSDATE
ALARMTABLE (Untitled4)
- SEND_USER_ID (보낸유저아이디) — VARCHAR(20) — Foreign key → USERTABLE.USER_ID — NOT NULL — PRIMERY KEY
- RECEIVE_USER_ID (받은 유저 아이디) — VARCHAR(20) — Foreign key → USERTABLE.USER_ID — NOT NULL — PRIMERY KEY
- ALARM_CONTENT (알람내용) — VARCHAR(30) — NOT NULL
- ALARM_DATE (알람 생성일) — DATE — NOT NULL
- 읽음여부 — VARCHAR(1) — NOT NULL
FRIENDTABLE (Untitled3)
- USER_ID (유저아이디) — VARCHAR(20) — Foreign key → USERTABLE.USER_ID — NOT NULL — PRIMERY KEY
- FRIEND_ID (친구아이디) — VARCHAR(20) — Foreign key → USERTABLE.USER_ID — NOT NULL — PRIMERY KEY
- 유저관계 — VARCHAR(1) — NOT NULL — DEFAULT 'N'
USERTABLE (Untitled)
- USER_ID (아이디) — VARCHAR(20) — Primary key — NOT NULL — PRIMERY KEY
- USER_PASSWORD (비밀번호) — VARCHAR(40) — NOT NULL
- USER_NAME (이름) — VARCHAR(20) — NOT NULL
- USER_EMAIL (이메일) — VARCHAR(50) — NOT NULL
- USER_DATE (가입날짜) — DATE — NOT NULL — DEFAULT SYSDATE
- USER_AUTHORITY (권한) — VARCHAR(1) — NOT NULL