Where'sMyMoney
Tables (8)
budget_category
- id — varchar(12) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
discord_service_type
- id — varchar(20) — Primary key — NOT NULL
- description — varchar(50)
id_sequence
- id — varchar(6) — Primary key — NOT NULL — 시퀀스 id
- no — int — NOT NULL — 시퀀스 no
user
- id — varchar(30) — Primary key — NOT NULL
- username — varchar(20) — NOT NULL
- password — varchar(100) — NOT NULL
- created_dt — datetime — NOT NULL
- updated_dt — datetime — NOT NULL
user_budget
- id — varchar(30) — Primary key — NOT NULL
- user_id — varchar(30) — Foreign key → user.id — NOT NULL
- budget — decimal(18,4)
- acc_spend — decimal(18,4)
- period_start — date — NOT NULL
- period_end — date — NOT NULL
- created_dt — datetime — NOT NULL
- updated_dt — datetime — NOT NULL
user_budget_category
- id — varchar(30) — Primary key — NOT NULL
- user_budget_id — varchar(30) — Foreign key → user_budget.id — NOT NULL
- budget_category_id — varchar(12) — NOT NULL
- budget — decimal(18,4)
- budget_per — decimal(18,4)
- acc_spend — decimal(18,4)
- created_dt — datetime — NOT NULL
- updated_dt — datetime — NOT NULL
user_discord_service
- user_id — varchar(30) — Primary key — NOT NULL
- service_id — varchar(20) — Primary key — NOT NULL
- discord_url — varchar(255) — NOT NULL
- created_dt — datetime
- updated_dt — datetime
user_spend_history
- id — varchar(30) — Primary key — NOT NULL
- user_budget_category_id — varchar(30) — Foreign key → user_budget_category.id — NOT NULL
- spend_amount — decimal(18,4)
- description — varchar(50)
- spend_date — date — NOT NULL
- is_sum — tinyint
- created_dt — datetime
- updated_dt — datetime