창고관리시스템
테이블 (5)
Customer
- Customer_ID (Key) — INTEGER — 기본 키 — NOT NULL
- Customer_Name (Field) — VARCHAR(50)
- Customer_email (Field2) — VARCHAR(50)
- Customer_HP (Field3) — VARCHAR(30)
Employee
- Employee_ID (Key) — INTEGER — 기본 키 — NOT NULL
- Name (Field) — VARCHAR(50)
- Position (Field2) — VARCHAR(50)
Request
- Request_ID (Key) — INTEGER — 기본 키 — NOT NULL
- Customer_ID (Field) — INTEGER
- Category_ID (Field2) — INTEGER
- Title (Field3) — VARCHAR(100)
- Content (Field4) — TEXT
- Status (Field5) — ENUM
- Created_At (Field6) — DATETIME
Request_Category
- Category_ID (Key) — INTEGER — 기본 키 — NOT NULL
- Name (Field) — VARCHAR(30)
Request_history
- History_ID (Key) — INTEGER — 기본 키 — NOT NULL
- Request_ID (Field) — INTEGER
- Employee_ID (Field2) — INTEGER
- Process_Content (Field3) — TEXT
- Processed_At (Field4) — DATETIME