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