oxtv
Tables (4)
comments
- id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → posts.id — NOT NULL
- user_id — int(11) — Foreign key → users.id — NOT NULL
- content — text
- created_at — datetime
- updated_at — datetime
file
- id — int(11) — Primary key — NOT NULL
- post_id — int(11) — Foreign key → posts.id — NOT NULL
- original_name — varchar(255)
- saved_name — varchar(255)
- upload_path — varchar(255)
- upload_date — datetime
- saved_path — varchar(255)
posts
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — mediumtext — NOT NULL
- created_at — datetime
- updated_at — datetime
- user_id — int(11) — Foreign key → users.id — NOT NULL
- category — varchar(255) — NOT NULL
users
- id — int(11) — Primary key — NOT NULL
- user_id — varchar(255) — NOT NULL
- user_password — varchar(255) — NOT NULL
- user_name — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- role — enum('ADMIN','USER') — NOT NULL