Krush

Tables (8)

daily_check (Untitled6)

  • Key — bigint(20) — Primary key — NOT NULL
  • Date (Field3) — date
  • Key (Key2) — bigint(20) — Foreign key → habit.Key — NOT NULL

habit (Untitled2)

  • Key — bigint(20) — Primary key — NOT NULL
  • Theme_Key (Key2) — bigint(20) — Foreign key → theme.Key — NOT NULL
  • Name (Field) — varchar(200)
  • Start_Date (Field2) — date
  • End_Date (Field3) — date
  • Memo (Field5) — varchar(200)
  • Like_Count (Field6) — int
  • Created_At (Field7) — timestamp
  • Updated_At (Field8) — timestamp
  • Status (Field9) — varchar(20)
  • User_Id (Key3) — bigint(20) — Foreign key → user.Key — NOT NULL

setting (Untitled8)

  • Key — bigint(20) — Primary key — NOT NULL
  • Criterion (a) — float

sticker (Untitled3)

  • Key — bigint(20) — Primary key — NOT NULL
  • Name (Field) — varchar(200)
  • Description (Field2) — varchar(200)
  • Image (Field3) — varchar(3000)
  • Created_At (Field4) — timestamp
  • Updated_At (Field5) — timestamp
  • Status (Field6) — varchar(20)
  • Price (Field7) — int
  • Level (Field8) — int

theme (Untitled5)

  • Key — bigint(20) — Primary key — NOT NULL
  • Background_Color (Field) — varchar(20)
  • Sticker_Id (Key2) — bigint(20) — Foreign key → sticker.Key — NOT NULL

user (Untitled)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Setting_Id (setting_id) — bigint(20) — Foreign key → setting.Key — NOT NULL
  • Nickname (nickname) — varchar(20)
  • SocialId (social_id) — varchar(255)
  • Created_At (created_at) — timestamp
  • Updated_At (updated_at) — timestamp
  • Status (status) — varchar(20)
  • Wallet_Key (wallet_key) — bigint(20) — Foreign key → wallet.Key — NOT NULL

user_sticker_junction (Untitled4)

  • User_Id (Key) — bigint(20) — Foreign key → user.Key — NOT NULL
  • Sticker_Id (Key2) — bigint(20) — Foreign key → sticker.Key — NOT NULL

wallet (Untitled7)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Coin (coin) — int
  • Exp (exp) — int
  • Created_At (created_at) — timestamp
  • Updated_At (updated_at) — timestamp
  • Status (status) — varchar(20)