Bill

Tables (9)

Bill (Untitled2)

  • Bill_id (Key) — Primary key — NOT NULL
  • name (Field)
  • Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL

FreeBoard (Untitled6)

  • FreeBoard_id (Key) — Primary key — NOT NULL
  • title (Field2)
  • content (Field)
  • Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL
  • AWSUrl (Field3)
  • imgName (Field4)

FreeComment (Untitled9)

  • FreeComment_id (Key) — Primary key — NOT NULL
  • content (Field)
  • FreeBoard_id (Key2) — Foreign key → FreeBoard.FreeBoard_id — NOT NULL
  • Member_id (Key3) — Foreign key → Member.Member_id — NOT NULL

Member (Untitled)

  • Member_id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)
  • role (Field4)
  • upgrade (Field5)

Money (Untitled4)

  • Money_id (Key) — Primary key — NOT NULL
  • borrowMoney (Field)
  • payMoney (Field2)
  • remainMoney (Field3)
  • borrowMoneyAll (Field4)
  • payMoneyAll (Field5)
  • borrowItemName (Field6)
  • payItemName (Field7)
  • RegistreBill_id (Key2) — Foreign key → RegistreBill.RegistreBill_id — NOT NULL

PatchBoard (Untitled10)

  • PatchBoard_id (Key) — Primary key — NOT NULL
  • title (Field)
  • Field2
  • Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL

Registre (Untitled5)

  • Registre_id (Key) — Primary key — NOT NULL
  • Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL
  • name (Field)

RegistreBill (Untitled3)

  • RegistreBill_id (Key) — Primary key — NOT NULL
  • Bill_id (Key2) — Foreign key → Bill.Bill_id — NOT NULL
  • Registre_id (Key3) — Foreign key → Registre.Registre_id — NOT NULL

UpBoard (Untitled7)

  • UpBoard_id (Key) — Primary key — NOT NULL
  • title (Field2)
  • content (Field)
  • Member_id (Key2) — Foreign key → Member.Member_id — NOT NULL