개척학기제

테이블 (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