unitice

Tables (9)

Untitled (university)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string — NOT NULL — ex) 고려대학교
  • Field (email) — string — NOT NULL — id느낌
  • Field (password) — string — NOT NULL — 암호화
  • Field (photo) — string — 프로필사진
  • Field (org_name) — string — NOT NULL — ex) 고려대학교 총학생회

Untitled (school)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string — NOT NULL
  • Key (university_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (email) — string — NOT NULL
  • Field (password) — string — NOT NULL
  • Field (photo) — string
  • Field (org_name) — string — NOT NULL

Untitled (department)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string — NOT NULL
  • Key (school_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (email) — string — NOT NULL
  • Field (password) — string — NOT NULL
  • Field (photo) — string
  • Field (org_name) — string — NOT NULL

Untitled (notice)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — string — NOT NULL
  • Field (content) — string — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (deleted_at) — timestamp
  • Field (images) — string[] — NOT NULL
  • Key (tag_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (department_id) — int — Foreign key → Untitled.Key
  • Key (school_id) — int — Foreign key → Untitled.Key
  • Key (university_id) — int — Foreign key → Untitled.Key

Untitled (tag)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string — NOT NULL

Untitled (tag_alert)

  • Key (id) — int — Primary key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Key (user_id) — string — Foreign key → user.Key — NOT NULL
  • Key (tag_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (mail_verification)

  • Key (id) — int — Primary key — NOT NULL
  • Field (email) — string — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (code) — string — NOT NULL

Untitled (read)

  • Key (id) — int — Primary key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Key (user_id) — string — Foreign key → user.Key — NOT NULL
  • Key (notice_id) — int — Foreign key → Untitled.Key — NOT NULL

user

  • Key (id) — string — Primary key — NOT NULL
  • Key (department_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (deleted_at) — timestamp
  • Field (student_id) — string — NOT NULL — unique
  • Field (push_token) — string — NOT NULL
  • Field (grade) — int — NOT NULL — 관계자는 9번..
  • Field (email) — string — NOT NULL
  • Field (year) — int — NOT NULL