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