개척학기제
테이블 (8)
Alram (Untitled7)
- subjectid (Key) — INT32 — 외래 키 → Subject.subjectid
- alramTime (Field1) — DATETIME
Dairy (Untitled5)
- dairyid (Key) — INT32 — 기본 키
- dairyExplain (Field1) — VARCHAR(80)
- dairyEmotion (Field2) — ENUM
Profile (PublicInfomation)
- userid (Key) — INT32 — 외래 키 → User.userid
- nickname (Unique1) — VARCHAR(60)
- age (Field1) — Short
- gender (Field2) — Bool
- subjectList (Field3) — LIST
- dairyList (Field4) — LIST
- successSubject (Field5) — DICT
Setting (Untitled)
- userid (Key) — INT32 — 외래 키 → User.userid
- soundAmount (Field) — Short
- showAlram (Field2) — Bool
- showAge (Field3) — Bool
- showGender (Field4) — Bool
Subject (Untitled4)
- subjectid (Key) — INT32 — 기본 키
- subjectName (Field1) — VARCHAR(60)
- subjectStatus (Field2) — Bool
- startDate (Field3) — DATETIME
- finishDate (Field4) — DATETIME
- successStatus (Field5) — Bool
- alramList (Field6) — LIST
User (personalInfomation)
- userid (Key) — INT32 — 기본 키
- id (Unique1) — VARCHAR(32)
- phoneNumber (Unique2) — VARCHAR(20) — NOT NULL
- name (Field1) — VARCHAR(60)
- password (Field2) — VARCHAR(255)
UserDairy (Untitled6)
- userDairyid (Key) — INT32 — 기본 키
- userid (Key1) — INT32 — 외래 키 → User.userid
- dairyid (Key2) — INT32 — 외래 키 → Dairy.dairyid
UserSubject (Untitled3)
- userSubjectid (Key) — INT32 — 기본 키
- subjectid (Key2) — INT32 — 외래 키 → Subject.subjectid
- userid (Key3) — INT32 — 외래 키 → User.userid