project

Tables (7)

Account

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • authortyId (Key2) — number — Foreign key → Authority.id — NOT NULL
  • appId (Key3) — number — Foreign key → AppSetting.id — NOT NULL
  • loginId (Field2) — string
  • passward (Field3) — string
  • createdAt (Field4) — datetime
  • updatedAt (Field5) — datetime

AppSetting

  • id (Key) — number — Primary key — NOT NULL
  • value (Field) — String

Authority

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — String

Calender

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • dateType (Field4) — String
  • today (Field5) — datetime
  • share (Field7) — string
  • gender (Field8) — string
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime
  • accountId (Key2) — number — Foreign key → Account.id — NOT NULL

LoginHistory

  • id (Key) — number — Primary key — NOT NULL
  • acountId (Key2) — number — Foreign key → Account.id — NOT NULL
  • cratedAt (Field) — datetime

SocialLogin

  • id (Key) — number — Primary key — NOT NULL
  • socialProvider (Field) — string
  • accountId (Key2) — number — Foreign key → Account.id — NOT NULL
  • createdAt (Field2) — datetime

Task

  • id (Key) — number — Primary key — NOT NULL
  • cartegory (Field) — eunm
  • content (Field2) — string
  • calenderId (Key2) — number — Foreign key → Calender.id — NOT NULL
  • createdAt (Field3) — datetime
  • updatedAt (Field4) — datetime
  • task (Field5) — string