JNU-Alarm
Tables (7)
Basic (기본)
- basicID (Key) — Int — Primary key — NOT NULL
- 학교 날씨 (Field) — 불
- 긴급 알림 (Field2) — 불
- Field3
College (단과대)
- collegeID (Key) — Int — Primary key — NOT NULL
- 공과대학 (Field) — Bool
- 예술대학 (Field2) — Bool
- 경영대학 (Field3) — Bool
- Field4
Department (학과)
- departmentID (Key) — Int — Primary key — NOT NULL
- 소프트웨어공학과 (Field) — Bool
HomePage (홈페이지)
- homePageID (Key) — Int — Primary key — NOT NULL
- 학사 (Field) — Bool
- 장학 (Field2) — Bool
- 취업 (Field3) — Bool
- 병무 (Field4) — Bool
Setting (설정)
- settingID (Key) — Int — Primary key — NOT NULL
- basicID (Key5) — Int — Foreign key → Basic.basicID — NOT NULL
- homePageID (Key4) — Int — Foreign key → HomePage.homePageID — NOT NULL
- collegeID (Key2) — Int — Foreign key → College.collegeID — NOT NULL
- departmentID (Key3) — Int — Foreign key → Department.departmentID — NOT NULL
Soft (소프트웨어공학과)
- Key — Primary key — NOT NULL
- title (Field) — String
- created_at (Field2) — Date
Users (사용자)
- id (Key) — Int — Primary key — NOT NULL
- settingID (Key3) — Int — Foreign key → Setting.settingID — NOT NULL
- deviceID (Field) — String
- fcmToken (Field2) — String