405
Tables (5)
Untitled (participant)
- Key (id) — int — Primary key — NOT NULL
- Key (room_id) — int — Foreign key → Untitled2.Key — NOT NULL
- id (user_id) — int — Foreign key → user.id — NOT NULL
Untitled (shoppingmall)
- Key (name) — varchar — Primary key — NOT NULL
- Field (url) — varchar
Untitled2 (room)
- Key (room_id) — int — Primary key — NOT NULL
- id (user_id) — int — Foreign key → user.id — NOT NULL
- Field (room_limit) — int
- Field2 (room_site) — varchar
- Field2 (room_url) — varchar
- Field (room_private) — boolean
- Field (room_pwd) — varchar
friend
- Key (id) — int — Primary key — NOT NULL
- id (user_id) — int — Foreign key → user.id — NOT NULL
- id (user_id2) — int — Foreign key → user.id — NOT NULL
user
- id (user_id) — int — Primary key — NOT NULL
- Field (user_name) — varchar
- Field (user_email) — varchar
- Field2 (user_photo) — varchar
- Field (user_phone) — varchar