잇그림스 시스템
테이블 (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)