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