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)