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)