miniproject
Tables (6)
POST
- post_id — Int — Primary key
- post_title (post-title) — varchar — NOT NULL
- post_content — text
- post_image
- create_time — DateTime
- update_time — DateTime
- user_id (user_id2) — int — Foreign key → Users.user_id — NOT NULL
Users
- user_id — int — Primary key — NOT NULL
- user_pw — varchar
- user_email — varchar
- create_time — DateTime
- update_time — DateTime
admin
- admin_id — Int — Primary key — NOT NULL
comments
- commentId — int — Primary key — NOT NULL
- content — text
- user_id — int
- create_time — DateTime
- update_time — DateTime
- post_id (post_id2) — Int — Foreign key → POST.post_id
likes
- user_id — int — Primary key — NOT NULL
- create_time — DateTime
- update_time — DateTime
- post_id (post_id2) — Int — Foreign key → POST.post_id
rank
- rank_id — Integer — Primary key — NOT NULL
- rank_name — varchar
- user_id — int — Foreign key → Users.user_id — NOT NULL