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)