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