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