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