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)