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

Untitled