SNS

Tables (5)

Comment (Untitled3)

  • Cnum — NOTNULL — Primary key — NOT NULL
  • Ctitle — NOTNULL
  • Ccontent — NOTNULL

Commenting (Untitled5)

  • ID — NOTNULL — Foreign key → User.ID — NOT NULL
  • Pnum — NOTNULL — Foreign key → Post.Pnum — NOT NULL
  • Cnum — NOTNULL — Foreign key → Comment.Cnum — NOT NULL
  • Cdate — NOTNULL

Post (Untitled2)

  • Pnum — NOTNULL — Primary key — NOT NULL
  • tilte (title) — NOTNULL
  • Pcontent — NOTNULL

Posting (Untitled4)

  • ID — NOTNULL — Foreign key → User.ID — NOT NULL
  • Pnum — NOTNULL — Foreign key → Post.Pnum — NOT NULL
  • Date — NOTNULL

User (Untitled)

  • ID — NOTNULL — Primary key — NOT NULL
  • pw — NOTNULL
  • name — NOTNULL
  • birth
  • tel