todomate
Tables (6)
Diary (Untitled4)
- id (Key) — AutoField — Primary key — NOT NULL
- user_id (PK) — AutoField — Foreign key → User.id — NOT NULL
- content (Field) — TextField
- bg_color (Field2) — TextField
- picture (Field3) — ImageField
- emoji (Field4) — CharField
- temperature (Field5) — DecimalField
- is_open (Field6) — IntegerField
- created_at (Field7) — DateTimeField
- updated_at (Field8) — DateTimeField
- deleted_at (Field9) — DateTimeField
DiaryLike (CopyOfUntitled5)
- id (Key) — AutoField — Primary key — NOT NULL
- diary_id (Key2) — AutoField — Foreign key → Diary.id — NOT NULL
- friend_id (PK) — AutoField — Foreign key → Diary.user_id — NOT NULL
- emoji (Field) — CharField
- created_at (Field2) — DateTimeField
- updated_at (Field3) — DateTimeField
- deleted_at (Field4) — DateTimeField
Todo (Untitled3)
- id (Key) — AutoField — Primary key — NOT NULL
- class_id (PK) — AutoField — Foreign key → TodoClass.id — NOT NULL
- user_id (FK) — AutoField — Foreign key → TodoClass.user_id — NOT NULL
- title (Field) — TextField
- is_finished (Field2) — BooleanField
- picture (Field3) — ImageField
- is_default (Field4) — BooleanField
- created_at (Field5) — DateTimeField
- updated_at (Field6) — DateTimeField
- deleted_at (Field7) — DateTimeField
TodoClass (Untitled2)
- id (PK) — AutoField — Primary key — NOT NULL
- user_id (FK) — AutoField — Foreign key → User.id — NOT NULL
- class_name (Field) — TextField
- class_color (Field2) — TextField
- is_open (Field3) — IntegerField
- created_at (Field4) — DateTimeField
- updated_at (Field5) — DateTimeFIeld
- deleted_at (Field6) — DateTimeField
TodoLike (Untitled5)
- id (Key) — AutoField — Primary key — NOT NULL
- friend_id (Key2) — AutoField — Foreign key → Todo.id — NOT NULL
- class_id (PK) — AutoField — Foreign key → Todo.class_id — NOT NULL
- user_id (FK) — AutoField — Foreign key → Todo.user_id — NOT NULL
- emoji (Field) — CharField
- created_at (Field2) — DateTimeField
- updated_at (Field3) — DateTimeField
- deleted_at (Field4) — DateTimeField
User (Untitled)
- id (PK) — AutoField — Primary key — NOT NULL
- nickname (Field2) — TextField
- username (Field3) — TextField
- password (Field) — TextField
- email (Field4) — TextField
- profile_image (Field5) — ImageField
- description (Field6) — TextField
- show_email (Field7) — BooleanField
- show_search (Field8) — BooleanField
- created_at (Field9) — DateTimeField
- updated_at (Field10) — DateTimeField
- deleted_at (Field11) — DateTimeField