project

Tables (4)

Answer (Untitled4)

  • AnswerID (Key) — int — Primary key — NOT NULL
  • UserID (Key2) — varchar(20) — Foreign key → User.UserID — NOT NULL
  • PostID (Key3) — int — Foreign key → Post.PostID — NOT NULL
  • AnswerContent (Field) — varchar(1028)
  • AnswerDate (Field2) — datetime

Category (Untitled3)

  • CategoryID (Key) — int — Primary key — NOT NULL
  • Categorytitle (Field) — varchar(50)

Post (Untitled2)

  • PostID (Key) — int — Primary key — NOT NULL
  • UserID (Key2) — varchar(20) — Foreign key → User.UserID — NOT NULL
  • CategoryID (Key3) — int — Foreign key → Category.CategoryID — NOT NULL
  • postTitle (Field) — varchar(50)
  • postDate (Field2) — datetime
  • postContent (Field3) — varchqr(2048)
  • postavailable (Field4) — int

User (Untitled)

  • UserID (Key) — varchar(20) — Primary key — NOT NULL
  • UserPassword (Field) — varchar(20) — NOT NULL
  • userEmail (Field2) — varchar(50) — NOT NULL
  • userName (Field3) — varchar(20)