prh
Tables (7)
channel
- channel_id — LONG — Primary key — NOT NULL
- team_id — LONG — Foreign key → team.team_id — NOT NULL
main_categories
- main_category_id — INT — Primary key
- sub_category_id — INT — Foreign key → sub_categories.sub_category_id
- main_category_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- available — BOOLEAN
notices
- notice_id — LONG — Primary key
- main_category_id — INT — Foreign key → main_categories.main_category_id
- sub_category_id — INT — Foreign key → main_categories.sub_category_id
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- author_id — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
refresh_tokens
- refresh_id — LONG — Primary key
- user_id (user_id2) — LONG — Foreign key → user.user_id — NOT NULL
- token — VARCHAR(512) — NOT NULL
- expires_at — DATETIME — NOT NULL
- revoked — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
sub_categories
- sub_category_id — INT — Primary key
- sub_category_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
team
- team_id — LONG — Primary key — NOT NULL
- team_name — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user
- user_id — LONG — Primary key — NOT NULL
- campus — ENUM
- classroom — INT
- name — VARCHAR(30)