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