DB_RYAN_original
Tables (10)
ChatMember (chatmember)
- userId + chatRoom.Id (user_id + chatRoom_id) — VARCHAR(20)
- joinTime (join_time) — TIMESTAMP
- hideName (hide_name) — VARCHAR(20)
- banCount (ban_count) — INT
- master(fk) — VARCHAR(20)
ChatMessage (chatmessage)
- id — VARCHAR(20) — Primary key — NOT NULL
- user_Id + chatRoom_Id (user_id + chatRoom_id) — VARCHAR(20)
- time — TIMESTAMP
- message
- picture
ChatRoom (chatroom)
- id — VARCHAR(20) — Primary key — NOT NULL
- roomNumber (room_number) — INT
- roomName (room_name) — VARCHAR(20)
- type
- password — VARCHAR(30)
- master(fk) — VARCHAR(20)
DM (dm)
- id — VARCHAR(20) — Primary key — NOT NULL
- sender — VARCHAR(20)
- receiver — VARCHAR(20)
- message — VARCHAR(20)
- time — TIMESTAMP
- isRead (is_read)
DMFile (dmfile)
- id — VARCHAR(20) — Primary key — NOT NULL
- DM_Id (dm_id) — VARCHAR(20)
- path — VARCHAR(20)
Feed (feed)
- id — VARCHAR(20) — Primary key — NOT NULL
- writer(fk) — VARCHAR(20)
- time — TIMESTAMP
- picture
- comment — VARCHAR(30)
Friends (friends)
- id — VARCHAR(20) — Primary key — NOT NULL
- requester(fk) — VARCHAR(20)
- receiver(fk) — VARCHAR(20)
- state
- time — TIMESTAMP
Item (item)
- id — VARCHAR(20) — Primary key — NOT NULL
- user_Id (user_id) — VARCHAR(20)
- name — VARCHAR(20)
- count — INT
- type
- value(effect type)
Like (like)
- id — VARCHAR(20) — Primary key — NOT NULL
- sender(fk) — VARCHAR(20)
- receiver(fk) — VARCHAR(20)
- FeedId (feed_id) — VARCHAR(20)
- time — TIMESTAMP
User (user)
- id — VARCHAR(20) — Primary key
- name — VARCHAR(20)
- password — VARCHAR(30)
- birth — VARCHAR(20)
- gender — VARCHAR(10)
- phoneNumber (phone_number) — VARCHAR(20)
- picture
- intro — VARCHAR(50)
- scope
- point — INT