sns service

Tables (6)

Untitled (friends)

  • Field (friend-id) — varchar
  • Key (id2) — int — Foreign key → register.Key — NOT NULL

like

  • Key (id) — int — Foreign key → register.Key — NOT NULL
  • Key (writeno) — int — Foreign key → writting.Key — NOT NULL

profile

  • Key (id) — int — Foreign key → register.Key — NOT NULL
  • Field (school) — varchar
  • Field (company) — varchar

register

  • Key (id) — int — Primary key — NOT NULL
  • Field (password) — int
  • Field (email) — varchar
  • Field (name) — varchar

reply

  • Field (reply) — varchar
  • Key (id) — int — Foreign key → register.Key — NOT NULL
  • Key (writeno) — int — Foreign key → writting.Key — NOT NULL

writting

  • Key (writeno) — int — Primary key — NOT NULL
  • Key (ment) — varchar — NOT NULL
  • Field (date) — int
  • Field (hits) — int
  • Field (like) — int
  • Key (id) — int — Foreign key → register.Key — NOT NULL