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

Untitled