SNS

Tables (7)

friends (Untitled3)

  • friends_number (Key) — Primary key — NOT NULL
  • oner (Key2) — Foreign key → member.id — NOT NULL
  • target (Key3) — Foreign key → member.id — NOT NULL

like (Untitled5)

  • id (Key) — Foreign key → member.id — NOT NULL
  • write number (Key2) — Foreign key → writing.write number — NOT NULL
  • date (Field)

member (Untitled)

  • id (Key) — Primary key — NOT NULL
  • pw (Field)
  • email (Field2)
  • name (Field3)

profile (Untitled2)

  • id (Key2) — Foreign key → member.id — NOT NULL
  • school (Field)
  • company (Field2)

reply (Untitled4)

  • write number (Key) — Foreign key → writing.write number — NOT NULL
  • id (Key2) — Foreign key → member.id — NOT NULL
  • content (Field)
  • date (Field2)

social _life (Untitled6)

  • id (Key2) — Foreign key → profile.id — NOT NULL
  • school/company (Field)
  • content (Field2)
  • procedure (Field3)

writing (Untitled7)

  • write number (Key) — Primary key — NOT NULL
  • comment (Field)
  • view (Field3)
  • registration date (Field2)
  • id (Key2) — Foreign key → member.id — NOT NULL