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