tiggle

Tables (9)

Copy Of Untitled (member_categories)

  • id (member_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • Key (id2) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Member (members)

  • id — bigint(20) — Primary key — NOT NULL
  • Field (email) — varchar(100) — NOT NULL
  • Field (profile_url) — varchar(255)
  • Field (birth) — date — NOT NULL
  • Field (nickname) — varchar(30) — NOT NULL
  • Field (provider) — varchar(255)
  • Field (provider_id) — varchar(255)
  • Field (deleted) — tinyint(1)
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp
  • Field (deleted_at) — timestamp

Transaction (transactions)

  • Id (id) — bigint(20) — Primary key — NOT NULL
  • Id (parent_id) — bigint(20) — Foreign key → Transaction.Id — NOT NULL
  • id (member_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • Key (asset_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Type (type) — enum('income', 'outcome','refund') — NOT NULL
  • Field (image_url) — varchar(255)
  • Field (amout) — int(11) — NOT NULL
  • Field (date) — date — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field (reason) — varchar(255) — NOT NULL
  • Field (tag_names) — varchar(255)
  • Field (deleted) — tinyint(1) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp
  • Field (deleted_at) — timestamp

Untitled (assets)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (defaults) — tinyint(1) — NOT NULL
  • Field (deleted) — tinyint(1) — NOT NULL

Untitled (member_assets)

  • id (member_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • Key (asset_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (categories)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (defaults) — tinyint(1) — NOT NULL
  • Field (deleted) — tinyint(1) — NOT NULL

Untitled (comments)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (parent_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Id (tx_id) — bigint(20) — Foreign key → Transaction.Id — NOT NULL
  • id (sender_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • id (receiver_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field (deleted) — tinyint(1) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp
  • Field (deleted_at) — timestamp

Untitled (tags)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (defaults) — tinyint(1) — NOT NULL
  • Field (tagged_count) — int(11) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

Untitled (notifications)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • id (sender_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • id (receiver_id) — bigint(20) — Foreign key → Member.id — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field (type) — enum('tx','comment','etc') — NOT NULL