창고관리시스템

테이블 (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