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