won-life

Tables (14)

Copy Of SUBGOALS (Subgoals)

  • subgoalIndex — int — Primary key — NOT NULL
  • goalIndex — int — Foreign key → Copy Of goals.goalIndex — NOT NULL
  • title — varchar(20)
  • isComplete (complete) — bool
  • completeTodo (complete_todo) — int
  • completeOption (complete_option) — enum("check","todo")
  • dueDate (due_date) — date
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime
  • Field (deleted_at) — datertime

Copy Of TODO2 (Todos)

  • todoIndex — int — Primary key — NOT NULL
  • subgoalIndex — int — Foreign key → Copy Of SUBGOALS.subgoalIndex — NOT NULL
  • title — varchar(30)
  • isFix (fix) — bool
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime
  • Field (deleted_at) — datetime

Copy Of TODOFEEDBACK (TodoFeedbacks)

  • todofeedbackIndex — int — Primary key — NOT NULL
  • todologIndex — int — Foreign key → Copy Of TODOLOG.todologIndex — NOT NULL
  • feedback — text
  • stauts (status) — enum("more","less","stay")
  • satisfaction — int
  • updatedAt (updated_at) — datetime
  • createdAt (created_at) — datetime
  • Field (deleted_at) — datetime

Copy Of TODOLOG (TodoLogs)

  • todologIndex — int — Primary key — NOT NULL
  • userIndex — int — Foreign key → Copy Of USER.userIndex — NOT NULL
  • valid — bool
  • isComplete (complete) — bool
  • createedAt (created_at) — datetime
  • updatedAt (updated_at) — datetime
  • Field (deleted_at) — datetime

Copy Of USER (Users)

  • userIndex — int — Primary key — NOT NULL
  • name — varchar(20)
  • id — varchar(20)
  • hashedPassword (hashed) — varchar(255)
  • salt — varchar(255)
  • email — varchar(30)
  • createdAt (created_at) — datetime
  • Field (deleted_at) — datetime
  • Field (updated_at) — datetime
  • Field (profile) — varchar(100)

Copy Of USERBUILDING (UserBuildings)

  • usebuildingIndex (userbuildingIndex) — int — Primary key — NOT NULL
  • usertownIndex — int — Foreign key → Copy Of USERTOWN.usertownIndex — NOT NULL
  • building (building_type) — enum("home","apart","building")
  • status — enum("none","start","almost","pending","done")
  • size — int
  • locaiton (location) — json
  • Field (deleted_at) — datetime
  • updatedAt (updated_at) — datetime
  • creaetedAt (created_at) — datetime

Copy Of USERTOWN (UserTowns)

  • usertownIndex — int — Primary key — NOT NULL
  • goalIndex — int — Foreign key → Copy Of goals.goalIndex — NOT NULL
  • theme — enum("basic","chirstmas","beach")
  • buildingNeed — int
  • matrix — json
  • updatedAt (updated_at) — datetime
  • createdAt (creaeted_at) — datetime
  • Field (deleted_at) — datetime

Copy Of WEEKLYPLAN (WeeklyTodos)

  • weeklytodoIndex — int — Primary key — NOT NULL
  • todoIndex — int — Foreign key → Copy Of TODO2.todoIndex — NOT NULL
  • day — ENUM('MON', 'TUE', 'WED', 'THU', 'FRI')
  • weekStartDate (week_strart_day) — datetime
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime
  • Field (deleted_at) — datetime

Copy Of goals (Goals)

  • goalIndex — int — Primary key — NOT NULL
  • userIndex — int — Foreign key → Copy Of USER.userIndex — NOT NULL
  • title — varchar(30) — NOT NULL
  • target_date — date
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

ad_rewards

  • id — uuid
  • user_id — uuid — NOT NULL
  • provider — text
  • placement — text
  • reward_amount — integer — NOT NULL
  • currency — text — NOT NULL
  • viewed_at — timestamptz — NOT NULL
  • tx_ledger_id — uuid

ledgers

  • id — uuid
  • user_id — uuid — NOT NULL
  • amount — integer — NOT NULL
  • currency — text — NOT NULL
  • type — ledger_type — NOT NULL
  • source — ledger_source — NOT NULL
  • ref_type — text
  • ref_id — uuid
  • memo — text
  • created_at — timestamptz — NOT NULL

subscriptions

  • id — uuid
  • user_id — uuid — NOT NULL
  • plan — text — NOT NULL
  • status — sub_status — NOT NULL
  • started_at — timestamptz — NOT NULL
  • canceled_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

user_preferences

  • id — uuid
  • user_id — uuid — NOT NULL
  • value — jsonb — NOT NULL

wallets

  • id — uuid
  • user_id — uuid — NOT NULL
  • balance — integer — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL