project12
Tables (10)
Copy Of food_kids_health (CopyOfUntitled5)
- item_code (Key) — char(10) — Primary key — NOT NULL
- flavor (Field) — varchar2(10)
- amount (Field2) — varchar2(5)
- shape (Field3) — varchar2(5)
- kinds (Field4) — varchar2(10)
- function (Field5) — varchar2(20)
- auth (Field6) — varchar2(20)
- additional (Field7) — varchar2(10)
- user (Field8) — varchar2(5)
- time (Field9) — varchar2(6)
- method_cook (Field10) — varchar2(10)
- keep (Field11) — varchar2(10)
- name (Field12) — varchar2(20)
- brand (Field13) — varchar2(10)
- card (Field14) — varchar2(10)
- delivery (Field15) — varchar2(10)
- price (Field16) — number(10)
- Field17
Copy Of food_kids_health2 (CopyOfUntitled52)
- item_code (Key) — char(10) — Primary key — NOT NULL
- name (Field12) — varchar2(20)
- price (Field16) — number(10)
Copy Of small_code (CopyOfUntitled2)
- small_code (Key) — char(2) — Primary key — NOT NULL
- mid_code (Key2) — char(2) — Foreign key → mid_code.mid_code — NOT NULL
- Large_code (Key22) — char(2) — Foreign key → mid_code.Large_code — NOT NULL
- small_name (Field) — varchar(10)
Copy Of sports_outdoor (CopyOfUntitled4)
- item_code (Key2) — char(10) — Primary key — NOT NULL
- user (Field2) — varchar2(5) — NOT NULL
- released (Field3) — char(6)
- spec (Field4) — varchar2(10)
- color (Field5) — varchar2(5)
- capacity (Field6) — varchar2(3)
- length (Field) — varchar2(3)
- frame (Field7) — varchar2(10)
- motor (Field8) — varchar2(10)
- add_spec (Field9) — varchar2(10)
- cloth_length (Field10) — varchar2(5)
- backStyle (Field11) — varchar2(10)
- wheel_size (Field12) — varchar2(5)
- name (Field13) — varchar2(20)
- brand (Field14) — varchar2(10)
- card (Field15) — varchar2(10)
- delivery (Field16) — varchar2(10)
- price (Field17) — number(10)
- Field18
code (Untitled6)
- code (Key3) — char(6) — Primary key — NOT NULL
- small_code (Key) — char(2) — Foreign key — NOT NULL
- mid_code (Key2) — char(2) — Foreign key — NOT NULL
- Large_code (Key22) — char(2) — Foreign key — NOT NULL
item (Untitled4)
- item_code (Key2) — char(10) — Primary key — NOT NULL
- small_code (Key) — char(2) — Foreign key → Copy Of small_code.small_code — NOT NULL
- mid_code (Key22) — char(2) — Foreign key → Copy Of small_code.mid_code — NOT NULL
- Large_code (Key222) — char(2) — Foreign key → Copy Of small_code.Large_code — NOT NULL
- name (Field13) — varchar2(20)
- price (Field17) — number(10)
- date (Field) — char(6)
large_code (Untitled)
- Large_code (Key) — char(2) — Primary key — NOT NULL
- large_name (Field) — varchar2(2)
mid_code (untitled)
- mid_code (Key) — char(2) — Primary key — NOT NULL
- Large_code (Key2) — char(2) — Foreign key → large_code.Large_code — NOT NULL
- mid_name (Field) — varchar(10)
option (Untitled3)
- item_code (Key4) — char(10) — Primary key — NOT NULL
- item_code (Key2) — char(10) — Foreign key → item.item_code — NOT NULL
- category_code (Key3) — char(4) — Foreign key → option_category.category_code — NOT NULL
- option_code (Key) — char(4) — Foreign key → option_category.option_code — NOT NULL
option_category (Untitled7)
- category_code (Key3) — char(4) — Primary key — NOT NULL
- option_code (Key) — char(4) — Primary key — NOT NULL
- small_code (Key4) — char(2) — Foreign key → Copy Of small_code.small_code — NOT NULL
- mid_code (Key23) — char(2) — Foreign key → Copy Of small_code.mid_code — NOT NULL
- Large_code (Key222) — char(2) — Foreign key → Copy Of small_code.Large_code — NOT NULL
- category_name (Field2) — varchar2(10)
- option_name (Field3) — varchar2(10)