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