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)