Skip to content

Database: Containers Table

Fifteen 15 Studios edited this page Jan 7, 2023 · 3 revisions

Description

Holds a list of containers.

Containers can hold collection items like coins, bills (banknotes), sets, books, or even other containers. A container might be a box, safe, or other item that holds your collection. If you have a box inside of a safe, then the safe would be the parent item of the box.

Fields

  • ID - BigInt(20) (UNSIGNED) (PRIMARY KEY),
  • Name - VarChar(100) (NOT NULL),
  • ParentID - BigInt(20) (UNSIGNED) (DEFAULT NULL)

Field Descriptions

  • ID - Unique identifier for this container
  • Name - String value of the name of the container
  • ParentID - Unique ID of the container that holds this container. Null if this container is not inside of another container.
    • REFERENCES: Containers.ID

Related Tables

Coins - Coins that can be in this container.

Bills - Bills (banknotes) that can be in this container.

Books - Books that can be in this container.

Clone this wiki locally