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