WMS_DashBoard
Tables (10)
Announcement (공지사항)
- ID (Id) — LongInteger — Primary key — NOT NULL
- Title — Text
- Content — Text
- RegiDate — DateTime
Export_Product (출고작업)
- Id — Long Integer — Primary key — NOT NULL
- Id (Id2) — LongInteger — Foreign key → Export_Progress_Status.Id — NOT NULL
- Export_Date (Exprt_Date) — DateTime
Export_Progress_Status (출고작업_진행상태)
- Id — LongInteger — Primary key — NOT NULL
- Expected — Boolean
- Picking — Boolean
- Loading — Boolean
- Export — Boolean
Import_Product (입고작업)
- Id — Long Integer — Primary key — NOT NULL
- Id (Id2) — LongInteger — Foreign key → Import_Progress_Status.Id — NOT NULL
- Import_Date — DateTime
Import_Progress_Status (입고작업_진행상태)
- Id — LongInteger — Primary key — NOT NULL
- Expected — Boolean
- Inspection — Boolean
- Confirm — Boolean
- Accumlation — Boolean
Product (상품정보)
- Id — LongInteger — Primary key — NOT NULL
- Id (Id2) — LongInteger — Foreign key → Product_Export_State.Id — NOT NULL
- Id (Id3) — LongInteger — Foreign key → WareHouse_Info.Id — NOT NULL
- Name — Text
- Amount — Int
Product_Export_State (상품출고상태)
- Id — LongInteger — Primary key — NOT NULL
- UnExport — Boolean
- Export — Boolean
Store_Status (보관현황)
- Id — Long Integer — Primary key — NOT NULL
- Product_Name — Text
Todo_List (Todo 리스트)
- ID (Id) — LongInteger — Primary key — NOT NULL
- Title — Text
- Content — Text
- RegiDate — DateTime
WareHouse_Info (창고정보)
- Id — LongInteger — Primary key — NOT NULL
- Name — Text
- Load_Amount — Integer