TODOMATE

Tables (3)

Diary (Untitled3)

  • id (PK) — AutoField — Primary key — NOT NULL
  • user_id (FK) — AutoField — Foreign key → User.id — NOT NULL
  • content (Field) — TextField
  • bg_color (Field2) — TextField
  • feeling_temp (Field3) — IntegerField
  • emoji (Field4) — CharField
  • is_secret (Field5) — IntegerField
  • created_at (Field6) — DateTimeField
  • updated_at (Field7) — DateTimeField
  • deleted_at (Field8) — DateTimeField

Todo (Untitled2)

  • id (PK) — AutoField — Primary key — NOT NULL
  • user_id (FK) — AutoField — Foreign key → User.id — NOT NULL
  • is_done (Field) — BooleanField
  • is_stored (Field2) — BooleanField
  • created_at (Field3) — DateTimeField
  • updated_at (Field4) — DateTimeField
  • deleted_at (Field5) — DateTimeField

User (Untitled)

  • id (PK) — AutoField — Primary key — NOT NULL
  • username (Field) — TextField
  • nickname (Field2) — TextField
  • password (Field3) — TextField
  • email (Field4) — TextField
  • profile_image (Field5) — ImageField
  • can_search_by_email (Field6) — TextField
  • is_shown (Field7) — TextField — NOT NULL
  • created_at (Field8) — DateTimeField — NOT NULL
  • updated_at (Field9) — DateTimeField
  • deleted_at (Field10) — DateTimeField