easybud
Tables (8)
Untitled (MEMBER)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (uid) — VARCHAR(50) — NOT NULL
- Field (social_provider) — VARCHAR(50) — NOT NULL
- Field (email) — VARCHAR(50) — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
- Field (role) — VARCHAR(50) — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
Untitled (TRANSACTION)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (date) — DATETIME — NOT NULL
- Field (summary) — VARCHAR(50) — NOT NULL
- Field (type) — VARCHAR(50) — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (ACCOUNT)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (type_name) — VARCHAR(50) — NOT NULL
- Field (type_state) — VARCHAR(50)v — NOT NULL
- Field (amount) — BIGDECIMAL — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
- Key (tertiary_category_id) — BIGINT — Foreign key → Untitled.Key
- Key (card_id) — BIGINT — Foreign key → Untitled.Key
- Key (transaction_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (PRIMARY_CATEGORY)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — VARCHAR(50) — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
Untitled (SECONDARY_CATEGORY)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — VARCHAR(50) — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
- Key (primary_category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (TERTIARY_CATEGORY)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — VARCHAR(50) — NOT NULL
- Field (is_default) — BOOLEAN — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (secondary_category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (CARD)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (start_date) — INTEGER — NOT NULL
- Field (end_date) — INTEGER — NOT NULL
- Field (payment_date) — INTEGER — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
- Field (summary) — VARCHAR(50) — NOT NULL
- Field (created_date) — DATETIME — NOT NULL
- Field (last_modified_date) — DATETIME — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL