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)