NTree

Tables (4)

Category (Untitled4)

  • category_id (id) — bigint — Primary key — NOT NULL
  • name — varchar(10)

Item (Untitled2)

  • item_id (id) — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → Category.category_id — NOT NULL
  • name — varchar(30)
  • is_available — bool
  • model_name — varchar(30)
  • description — varchar(300)
  • pin_layout_image_url — varchar(8200)
  • circuit_image_url — varchar(8200)
  • code_ref_url — varchar(255)
  • created_at — datetime(6)
  • updated_at — datetime(6)

Order (Untitled)

  • id — bigint — Primary key — NOT NULL
  • item_id — bigint — Foreign key → Item.item_id — NOT NULL
  • team_id — bigint — Foreign key → Team.team_id — NOT NULL
  • is_issued — bool
  • created_at — datetime(6)
  • updated_at — datetime(6)

Team (Untitled3)

  • team_id (id) — bigint — Primary key — NOT NULL
  • name — varchar(15)
  • team_number — int
  • phone_number — varchar(13)
  • created_at — datetime(6)
  • updated_at — datetime(6)