donkeeper
Tables (15)
Copy Of Copy Of MEMBER (INCOME)
- Key (income_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Key (income_classification_id) — bigint(20) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Key (asset_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (date) — datetime — NOT NULL
- Field (amount) — bigint(20) — NOT NULL
- Field (detail) — varchar(255)
- Field2 (memo) — text
Copy Of MEMBER (SPENDING)
- Key (spending_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Key (asset_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (spending_classification_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (date) — datetime — NOT NULL
- Field (amount) — int — NOT NULL
- Field (detail) — varchar(255)
- Field2 (memo) — text
Copy Of Untitled (INCOME_CLASSIFICATION)
- Key (income_classification_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
MEMBER
- Key (member_id) — bigint(20) — Primary key — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (oauth) — varchar(255)
- Field2 (nickname) — varchar(255) — NOT NULL
Untitled (MEMBER_GROUP)
- Key (member_group_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Key (group_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (ranking) — bigint(20) — NOT NULL
- Field (nickname) — varchar(255) — NOT NULL
Untitled (GROUP)
- Key (group_id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (create_date) — datetime — NOT NULL
Untitled (ASSET)
- Key (asset_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (total_account) — bigint(20) — NOT NULL
Untitled (SPENDING_CLASSIFICATION)
- Key (spending_classification_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Key (major_spending_classification_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
Untitled (BUDGET)
- Key (budget_id) — bigint(2) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Key (major_spending_classification_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (year_month) — datetime — NOT NULL
- Field (amount) — bigint(20) — NOT NULL
Untitled (CHALLENGE)
- Key (challenge_id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (start_date) — datetime — NOT NULL
- Field (end_date) — date_time — NOT NULL
- Field (detail) — text — NOT NULL
Untitled (MEMBER_CHALLENGE)
- Key (member_challenge_id) — bigint(20) — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → MEMBER.Key — NOT NULL
- Key (challenge_id2) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (check_date) — datetime — NOT NULL
- Field (start_date) — datetime — NOT NULL
- Field (end_date) — datetime — NOT NULL
Untitled (CARD)
- Key (card_id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (enterprise_url) — varchar(255) — NOT NULL
- Field (annual_fee) — bigint(20) — NOT NULL
- Field (performance_amount) — bigint(20) — NOT NULL
Untitled (CARD_BENEFIT)
- Key (card_benefit_id) — bigint(20) — Primary key — NOT NULL
- Key (card_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (detail) — varchar(255) — NOT NULL
Untitled (MAJOR_SPENDING_CLASSIFICATION)
- Key (major_spending_classification_id) — int — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL