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