cotato-study-platform
Tables (4)
revoked_token
- id — BIGINT — Primary key — NOT NULL
- jti — VARCHAR(64) — NOT NULL
- expires_at — DATETIME — NOT NULL
study_post
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- study_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
study_post_comment
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- study_post_id — BIGINT — Foreign key → study_post.id — NOT NULL
- content — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(10) — NOT NULL
- generation — INT — NOT NULL
- part — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL