IOT
Tables (8)
Calendar
- calendar_id — INT — NOT NULL
- user_id — INT — NOT NULL
- calendar_name — TEXT
- date — DATE
Diary
- diary_id — INT — NOT NULL
- calendar_id — INT — NOT NULL
- diary_summary — TEXT
- diary_full — TEXT
- emotion — TEXT
OAuthId
- OAuthServerId — TEXT
- OAuthServerType — TEXT
Report
- report_id — INT — NOT NULL
- user_id — INT — NOT NULL
- start_date — DATE
- end_date — DATE
- emotion_analysis — TEXT
SampleText
- sampleText_id — INT — NOT NULL
- category_id — INT — NOT NULL
- text_content — TEXT
Schedule
- schedule_id — INT — NOT NULL
- calendar_id — INT — NOT NULL
- schedule_name — TEXT
- start_time — TIME
- end_time — TIME
- description — TEXT
TextCategory
- category_id — INT — NOT NULL
- category_name — TEXT
User
- id — INT — NOT NULL
- username — TEXT — NOT NULL
- email — TEXT
- password — TEXT — NOT NULL
- role — TEXT
- oauthId — TEXT