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