scrooge_alone
Tables (5)
Category (Untitled3)
- id (PK) — int — Primary key — NOT NULL
- name (Field) — varchar(20)
Member (Untitled)
- id (PK) — int — Primary key — NOT NULL
- member_id (Field) — varchar(20)
- nickname (Field2) — varchar(20)
- password (Field3) — varchar(40)
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
Payment (Untitled4)
- id (PK) — int — Primary key — NOT NULL
- name (Field) — varchar(20)
Record (Untitled2)
- id (PK) — int — Primary key — NOT NULL
- member_id (PK2) — varchar(20) — Foreign key → Member.id — NOT NULL
- category_id (FK) — int — Foreign key → Category.id — NOT NULL
- id (PK3) — int — Foreign key → Payment.id — NOT NULL
- amount (Field) — int
- content (Field2) — varchar(200)
- date (Field3) — timestamp
- income (Field5) — boolean
Wish (Untitled5)
- id (PK) — int — Primary key — NOT NULL
- member_id (PK2) — int — Foreign key → Member.id — NOT NULL
- name (Field) — varchar(40)
- price (Field2) — int
- reason (Field3) — varchar(400)
- value (Field4) — double