Sub_PJT1
Tables (3)
Comments (comment)
- comment_id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → Post.post_id — NOT NULL
- uid — char — Foreign key → User.uid — NOT NULL
- create_date — datetime
- Field
Post (post)
- post_id — INT — Primary key — NOT NULL
- uid — char — Foreign key → User.uid — NOT NULL
- title (itle) — varchar
- content — varchar
- create_date — datetime
User (user)
- uid — char — Primary key — NOT NULL
- email — varchar
- password — varchar
- create_date — datetime