chatting
Tables (3)
ACTION (Untitled2)
- ID (아이디) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL — PRIMERY KEY
- ACTION_STATUS (로그인상태) — VARCHAR(1) — NOT NULL — DEFAULT 'N'
- ACTION_LAST_TIME (마지막 로그인 시간) — DATE — NOT NULL — DEFAULT SYSDATE
FRIEND (Untitled3)
- USER_ID (아이디) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL — PRIMERY KEY
- FRIEND_ID (친구아이디) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL — PRIMERY KEY
- RELATION (유저관계) — VARCHAR(1) — NOT NULL — DEFAULT 'N'
USER (Untitled)
- ID (아이디) — VARCHAR(20) — Primary key — NOT NULL — PRIMERY KEY
- PASS (비밀번호) — VARCHAR(40) — NOT NULL
- NAME (이름) — VARCHAR(20) — NOT NULL
- EMAIL (이메일) — VARCHAR(50) — NOT NULL
- JOIN_DATE (가입날짜) — DATE — NOT NULL — DEFAULT SYSDATE
- AUTHORITY (권한) — VARCHAR(1) — NOT NULL