잇그림스 시스템

테이블 (19)

Box_Assign (Untitled18)

  • BoxAssignId (Key) — 기본 키 — NOT NULL
  • ContainerBoxId (Key2) — 외래 키 → Container_Box.ContainerBoxId — NOT NULL
  • CustomerDistributionId (Key3) — 외래 키 → Customer_Distribution.CustomerDistributionId — NOT NULL
  • AssignedTime (Field)
  • ReleasedTime (Field2)

Box_Return (Untitled19)

  • BoxReturnId (Key) — 기본 키 — NOT NULL
  • ContainerBoxId (Key2) — 외래 키 → Container_Box.ContainerBoxId — NOT NULL
  • CustomerId (Key3) — 외래 키 → Customer.CustomerId — NOT NULL
  • ReturnTime (Field)

Conatiner_Log_Return (Untitled6)

  • ContainerLogReturnId (Key) — 기본 키 — NOT NULL
  • ContainerLogId (Key2) — 외래 키 → Container_Log.ContainerLogId — NOT NULL
  • Address (Field)
  • PhoneNumber (Field2)

Container(용기) (Untitled)

  • ContainerId (Key) — 기본 키 — NOT NULL
  • ContainerClassCodeId (Key2) — 외래 키 → Container_Class_Code.ContainerClassCodeId — NOT NULL
  • ContainerStateCodeId (Key3) — 외래 키 → Container_State_Code.ContainerStateCodeId — NOT NULL
  • LocationCodeId (Key4) — 외래 키 → Location_Code.LocationCodeId — NOT NULL

Container_Assign (Untitled17)

  • ContainerAssignId (Key) — 기본 키 — NOT NULL
  • ContainerId (Key2) — 외래 키 → Container(용기).ContainerId — NOT NULL
  • ContainerBoxId (Key3) — 외래 키 → Container_Box.ContainerBoxId — NOT NULL
  • OrderId (Key4) — 외래 키 → Order.OrderId — NOT NULL
  • AssignedTime (Field)
  • ReleasedTime (Field2)

Container_Box (Untitled16)

  • ContainerBoxId (Key) — 기본 키 — NOT NULL
  • BoxQuantity (Field)
  • BoxState (Field2)

Container_Class_Code (Untitled2)

  • ContainerClassCodeId (Key) — 기본 키 — NOT NULL
  • ContainerClass (Field)
  • Material (Field2)

Container_Log (Untitled5)

  • ContainerLogId (Key2) — 기본 키 — NOT NULL
  • ContainerId (Key) — 외래 키 → Container(용기).ContainerId — NOT NULL
  • PreviousState (Field)
  • NextState (Field2)
  • PreviousLocation (Field3)
  • NextLocation (Field4)
  • Time (Field5)

Container_State_Code (Untitled3)

  • ContainerStateCodeId (Key) — 기본 키 — NOT NULL
  • State (Field)

Customer (Untitled7)

  • CustomerId (Key) — 기본 키 — NOT NULL
  • CustomerClassCodeId (Key2) — 외래 키 → Customer_Class_Code.CustomerClassCodeId — NOT NULL
  • CustomerName (Field)
  • CustomerAddress (Field2)
  • CustomerState (Field3)

Customer_Baseball (Untitled13)

  • CustomerBaseballId (Key) — 기본 키 — NOT NULL
  • CustomerId (Key2) — 외래 키 → Customer.CustomerId — NOT NULL
  • SeasonStartTime (Field)
  • SeasonEndTime (Field2)

Customer_Business (Untitled11)

  • CustomerBusinessId (Key) — 기본 키 — NOT NULL
  • CustomerId (Key2) — 외래 키 → Customer.CustomerId — NOT NULL
  • BusinessType (Field)

Customer_Class_Code (Untitled8)

  • CustomerClassCodeId (Key) — 기본 키 — NOT NULL
  • CustomerClass (Field)

Customer_Distribution (Untitled15)

  • CustomerDistributionId (Key) — 기본 키 — NOT NULL
  • CustomerId (Key2) — 외래 키 → Customer.CustomerId — NOT NULL
  • Distribution (Field)

Customer_Event (Untitled12)

  • CustomerEventId (Key) — 기본 키 — NOT NULL
  • CustomerId (Key2) — 외래 키 → Customer.CustomerId — NOT NULL
  • EventStartTime (Field)
  • EventEndTime (Field2)

Customer_Store (Untitled14)

  • CustomerStoreId (Key) — 기본 키 — NOT NULL
  • CustomerId (Key2) — 외래 키 → Customer.CustomerId — NOT NULL

Location_Code (Untitled4)

  • LocationCodeId (Key) — 기본 키 — NOT NULL
  • Location (Field)

Order (Untitled9)

  • OrderId (Key) — 기본 키 — NOT NULL
  • CustomerId (Key2) — 외래 키 → Customer.CustomerId — NOT NULL
  • OrderState (Field)
  • OrderTime (Field2)
  • AcceptedTime (Field3)
  • DeliveredTime (Field4)

Order_List (Untitled10)

  • OrderListId (Key) — 기본 키 — NOT NULL
  • OrderId (Key2) — 외래 키 → Order.OrderId — NOT NULL
  • ContainerClassCodeId (Key3) — 외래 키 → Container_Class_Code.ContainerClassCodeId — NOT NULL
  • Quantity (Field)
  • Price (Field2)
  • TotalPrice (Field3)