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