project3rd
Tables (5)
p3_post_comments
- id — int(11) — Primary key — NOT NULL
- post_id — int(255) — Foreign key → p3_posts.id
- user_id — int(255)
- comment — varchar(1000)
- created_at — datetime
p3_post_files
- id — int(255) — Primary key — NOT NULL
- post_id — int(255) — Foreign key → p3_posts.id — NOT NULL
- file_name — varchar(255) — NOT NULL
- uploaded_at — datetime — NOT NULL
p3_post_likes
- post_id — int(255) — Primary key — NOT NULL
- user_id — int(255) — Foreign key → p3_users.id — NOT NULL
- liked_at — datetime — NOT NULL
p3_posts
- id — int(255) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- category — varchar(255) — NOT NULL
- explain — text — NOT NULL
- author_id — int(255) — NOT NULL
- datetime — datetime — NOT NULL
p3_users
- id — int(255) — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL