SampleChatting

Tables (7)

ADDRESS

  • ID (id) — int(11) — Primary key — NOT NULL
  • DO (do) — varchar(20)
  • SI (si) — varchar(20)
  • FULLADDRESS (fulladdress) — varchar(20)
  • UPDATEDATE (updatedate) — date
  • CREATEDATE (createdate) — date

FREINDLIST

  • ID (id) — int(11) — Primary key — NOT NULL
  • FREINDID (freindid) — int(11) — Foreign key → User.ID — NOT NULL

ROOMMESAGE

  • ID (id) — int(11) — Primary key — NOT NULL
  • USERID (userid) — int(11) — Foreign key → User.ID — NOT NULL
  • ROOMSID (roomsid) — int(11) — Foreign key → ROOMS.ID — NOT NULL
  • MESSAGES (messages) — varchar(20)
  • UPDATEDATE (updatedate) — date
  • CREATEDATE (createdate) — date

ROOMS

  • ID (id) — int(11) — Primary key — NOT NULL
  • ROOOMNAME (roomname) — varchar(20)
  • MAX (max) — int(11)
  • UPDATEDATE (updatedate) — date
  • CREATEDATE (createdate) — date

ROOMUSERS

  • ID (id) — int(11) — Primary key — NOT NULL
  • USERID (userid) — int(11) — Foreign key → User.ID — NOT NULL
  • ROOMID (roomid) — int(11) — Foreign key → ROOMS.ID — NOT NULL
  • UPDATEDATE (updatedate) — date
  • CREATEDATE (createdate) — date

User

  • ID (id) — int(11) — Primary key — NOT NULL
  • ADDRESSID (addressid) — int(11) — Foreign key → ADDRESS.ID — NOT NULL
  • FREINDS (freinds_id) — int(11)
  • USERID (userid) — VARCHAR(20)
  • USERNAME (username) — VARCHAR(20)
  • USERPASSWORD (userpassword) — VARCHAR(20)
  • EMAIL (email) — VARCHAR(20)
  • PHONENUMBER (phonenumber) — VARCHAR(20)
  • AGE (age) — int(10)
  • ISUSE (isuse) — VARCHAR(20)
  • UPDATEDATE (updatedate) — date
  • CREATEDATE (createdate) — date

WHISPERMESSAGE

  • ID (id) — int(11) — Primary key — NOT NULL
  • SENDER (sender) — varchar(20)
  • RECIVER (reciver) — varchar(20)
  • UPDATEDATE (updatedate) — date
  • CREATEDATE (createdate) — date