java

Tables (5)

InOut (입출고)

  • item_name (Field) — varchar(20)
  • kind_code (Field2) — number
  • item_price (Field3) — varchar(20)
  • item_count (Field4) — varchar(20)
  • item_code (PK) — not null — Foreign key → WareHouse_list.item_code — NOT NULL
  • store_code (PK2) — not null — Foreign key → Sub_Store.store_code — NOT NULL
  • kind_code (FK) — not null — Foreign key → Sub_Store.kind_code — NOT NULL — fsdfsdfsd

Kind_list (상품대소분류)

  • kind_code (PK) — not null — Primary key — NOT NULL — fsdfsdfsd
  • kind_name (Field) — varchar(20)

Location_Popular_items (지역별 인기상품)

  • kind_code (FK) — not null — Foreign key → Sub_Store.kind_code — NOT NULL — fsdfsdfsd
  • item_name (Field2) — number
  • item_price (Field3) — varchar(20)
  • item_count (Field4) — varchar(20)
  • store_code (PK2) — not null — Foreign key → Sub_Store.store_code — NOT NULL
  • item_code (FK1) — not null — Foreign key → WareHouse_list.item_code — NOT NULL

Sub_Store (지점1)

  • store_code (PK) — not null — Primary key — NOT NULL
  • kind_code (FK) — not null — Foreign key → Kind_list.kind_code — NOT NULL — fsdfsdfsd
  • store_name (Field) — varchar(20)
  • store_phone (Field2) — number
  • sitem_code (Field3) — varchar(20)
  • sitem_name (Field4) — varchar(20)
  • sitem_price (Field5) — number

WareHouse_list (창고(본사))

  • item_code (PK) — not null — Primary key — NOT NULL
  • kind_code (Field) — varchar(20)
  • item_name (Field2) — number
  • item_price (Field3) — varchar(20)
  • item_count (Field4) — varchar(20)