DutchBroomstick

Tables (7)

Credit (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • amount (Field3) — float
  • payment (Key2) — Payment — Foreign key → Payment.id — NOT NULL
  • to (Key3) — Member — Foreign key → Member.id — NOT NULL

Layer (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • number (Field) — int
  • name (Field3) — string
  • currency (Field2) — string
  • room (Key2) — Room — Foreign key → Room.id — NOT NULL

Member (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • nickname (Field) — string
  • account (Field2) — string
  • room (Key3) — Room — Foreign key → Room.id — NOT NULL
  • user (Key2) — User — Foreign key → User.id — NOT NULL

Payment (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • timestamp (Field) — datetime
  • for (Field2) — string
  • layer (Key3) — Layer — Foreign key → Layer.id — NOT NULL
  • from (Key2) — Member — Foreign key → Member.id — NOT NULL

Profile (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • default_nickname (Field) — string
  • default_account (Field2) — string
  • user (Key2) — User — Foreign key → User.id — NOT NULL

Room (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • url (Field2) — string
  • name (Field) — string
  • owner (Key2) — User — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • username (Field2) — string
  • password (Field) — string