SNS

Tables (6)

Untitled (JOIN)

  • Key (ID) — varchar(50) — Primary key — NOT NULL
  • Field (PW) — varchar(50) — NOT NULL
  • Field (email) — varchar(50) — NOT NULL
  • Field (name) — varchar(50) — NOT NULL

Untitled (Profile)

  • Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (School) — varchar(50)
  • Field (Company) — varchar(50)

Untitled (Post)

  • Key (PostNo) — int(10) — Primary key — NOT NULL
  • Field (date) — varchar(20) — NOT NULL
  • Field (memo) — varchar(1000) — NOT NULL
  • Field (view) — int(10) — NOT NULL
  • Field (Likes) — int(10) — NOT NULL
  • Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL

Untitled (Reply)

  • Key (ReplNo) — int(10) — Primary key — NOT NULL
  • Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Key (PostNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (comment) — varchar(200) — NOT NULL

Untitled (Likes)

  • Key (PostNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL

Untitled (Friends)

  • Field (Friend_ID) — varchar(50) — NOT NULL
  • Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL