SNS ERD

Tables (4)

ChatRoom (Untitled)

  • room_uid (Key) — bigint(20) — Primary key — NOT NULL
  • uid — bigint(20) — Foreign key → User.uid — NOT NULL
  • created (Field3) — datetime — NOT NULL

Follow Status

  • my_uid — bigint(20) — Foreign key → User.uid — NOT NULL
  • friend_uid (Field) — bigint(20) — NOT NULL
  • status — bit(1) — NOT NULL

Message

  • message_uid (Key) — bigint(20) — Primary key — NOT NULL
  • message_room_uid (Key2) — bigint(20) — Foreign key → ChatRoom.room_uid — NOT NULL
  • message_text (Field) — varchar(255) — NOT NULL
  • created (Field2) — datetime — NOT NULL
  • Field3

User

  • uid — bigint(20) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • id — varchar(20) — NOT NULL
  • password — char(255) — NOT NULL
  • lastlogin — datetime — NOT NULL