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