ZPND-ERP

Tables (15)

Account (거래처 테이블)

  • id (Account id) — Auto Increment — Primary key — NOT NULL
  • acaddress (Account Address) — varchar(100)
  • accode (Account Code) — varchar(20)
  • accompany (Account Company) — varchar(30)
  • acdate (First Transaction Date) — varchar(10)
  • acicode (Account Item Code) — varchar(11)
  • acitem (Account Item Name) — varchar(30)
  • acnum (Company Phone Number) — varchar(13)
  • acprice (Item Price) — numeric(7)
  • vat (VAT) — decimal(4, 2)

Attendance (출퇴근 관리 테이블)

  • id (Attendance ID) — Auto Increment — Primary key — NOT NULL
  • id (Employee id2) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Department id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Position id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Spot id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • day (Attendance Day) — date
  • check_in_time (Attendance Time) — time
  • check_out_time (Leave Work Time) — time
  • workingtime (Working Time) — varchar(255)
  • employee_id (Employee id) — Auto Increment

Department (부서정보 테이블)

  • id (Department id) — Auto Increment — Primary key — NOT NULL
  • depcode (Department Code) — int
  • dema,e (Department Name) — varchar(255)

Employee (사원정보 테이블)

  • id (Employee id) — Auto Increment — Primary key — NOT NULL
  • id (Department id) — Auto Increment — Foreign key → Department.id — NOT NULL
  • id (Position id) — Auto Increment — Foreign key → Position.id — NOT NULL
  • id (Spot id) — Auto Increment — Foreign key → Spot.id — NOT NULL
  • empadd (Employee Address) — varchar(50)
  • empdate (Date of Joining) — date
  • empmail (Employee E-Mail) — varchar(50)
  • empname (Employee Name) — varchar(50)
  • empnum (Employee Number) — varchar(50)
  • empphone (Employee Phone) — varchar(50)
  • empssn (Social Security Number) — varchar(50)
  • password (Password) — varchar(255)

Inventory (재고 테이블)

  • inid (Inventory ID) — Auto Increment — Primary key — NOT NULL
  • id (Employee id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Department id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Position id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Spot id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • itm_id (id2) — Auto Increment — Foreign key → Item.itm_id — NOT NULL
  • ig_id (Item_Group id) — Auto Increment — Foreign key → Item.ig_id — NOT NULL
  • ic_id (Item_Category id) — Auto Increment — Foreign key → Item.ic_id — NOT NULL
  • innum (Inventory Number) — varchar(255)
  • indate (Inventory Date) — date
  • inquantity (Inventory Quantity) — int
  • create_date (Inventory Create Date) — datetime
  • modify_date (Modify Date) — datetime
  • employee_id (Employee ID) — Auto Increment
  • Item_itm_id (Item ID) — Auto Increment

Item (품목테이블)

  • itm_id (id) — Auto Increment — Primary key — NOT NULL
  • ig_id (Item_Group id) — Auto Increment — Foreign key → Item_Group.ig_id — NOT NULL
  • ic_id (Item_Category id) — Auto Increment — Foreign key → Item_Category.ic_id — NOT NULL
  • create_date (Create Date) — datetime
  • itm_code (Item Code) — varchar(255)
  • itm_name (Item Name) — varchar(255)
  • itm_rprice (Sales Amount) — int
  • itn_sprice (Purchase Amoun) — int
  • itm_standard (Item Standard) — varchar(255)
  • itm_category_ic_id (Category id) — int
  • itm_group_ig_id (Group id) — int

Item_Category (품목 카테고리 테이블)

  • ic_id (Item_Category id) — Auto Increment — Primary key — NOT NULL
  • ic_code (Item_Category code) — varchar(6)
  • ic_name (Item_Category name) — varchar(10)

Item_Group (품목 그룹 테이블)

  • ig_id (Item_Group id) — Auto Increment — Primary key — NOT NULL
  • ig_code (Item_Group code) — varchar(255)
  • ig_name (Item_Group Name) — varchar(255)

Orders (발주 테이블)

  • id (Orders id) — Auto Increment — Primary key — NOT NULL
  • id (Purchase id) — Auto Increment — Foreign key → Purchase.id — NOT NULL
  • id (Account id) — Auto Increment — Foreign key → Purchase.id — NOT NULL
  • orcode (Order Company Code) — varchar(20)
  • orcompany (Order Company) — varchar(30)
  • orcp (Supply Price) — numeric(12)
  • ordate (Order Date) — date
  • oricode (Order Item Code) — varchar(11)
  • oritem (Order Item) — varchar(30)
  • ornum (Order Number) — varchar(13)
  • orvat (VAT amount) — numeric(12)
  • orvatsum (Total Amount) — numeric (15)
  • vat (VAT) — decimal(4, 2)

Position (직책 테이블)

  • id (Position id) — Auto Increment — Primary key — NOT NULL
  • positioncode (Position Code) — int
  • positionname (Position Name) — varchar(255)

Purchase (구매 테이블)

  • id (Purchase id) — Auto Increment — Primary key — NOT NULL
  • id (Account id) — Auto Increment — Foreign key → Account.id — NOT NULL
  • pccode (Company Code) — varchar(20)
  • pccompany (Puchase Company) — varchar(30)
  • pccount (Item Count) — numeric(3)
  • pcprice (Item Price) — numeric(7)
  • pccp (Supply Price) — numeric(12)
  • pcvat (VAT amount) — numeric(12)
  • pcvatsum (Total Amount) — numeric (15)
  • pcnum (Purchase Number) — varchar(10)
  • pcitem (Purchase Item) — varchar(30)
  • pcicode (Purchase Item Code) — varchar(11)
  • pcdate (Purchase Date) — varchar(10)

Reservation (예약 테이블)

  • id (Reservation id) — Auto Increment — Primary key — NOT NULL
  • itm_id (id2) — Auto Increment — Foreign key → Item.itm_id — NOT NULL
  • ig_id (Item_Group id) — Auto Increment — Foreign key → Item.ig_id — NOT NULL
  • ic_id (Item_Category id) — Auto Increment — Foreign key → Item.ic_id — NOT NULL
  • rvnum (Reservation Number) — varchar(11)
  • rvdate (Reservation Date) — datetime
  • rvitem (Reservation Item) — varchar(30)
  • rvicode (Reservation Item Code) — varchar(50)
  • rvcount (Reservation Item Count) — numeric(3)
  • rvprice (Reservation Item Price) — numeric(7)
  • rvcp (Supply Price) — numeric(12)
  • rvvat (VAT Price) — numeric(10)
  • rvsum (Total Amount) — numeric(15)
  • rvpick (Pick-up Status) — boolean
  • rvptime (Pick-up Time) — datetime

Sales (판매 테이블)

  • id (Sales id) — Auto Increment — Primary key — NOT NULL
  • id (Reservation id) — Auto Increment — Foreign key → Reservation.id — NOT NULL
  • itm_id (id2) — Auto Increment — Foreign key → Reservation.itm_id — NOT NULL
  • ig_id (Item_Group id) — Auto Increment — Foreign key → Reservation.ig_id — NOT NULL
  • ic_id (Item_Category id) — Auto Increment — Foreign key → Reservation.ic_id — NOT NULL
  • sanum (Sales Number) — varchar(11)
  • sadate (Sales Date) — date
  • samethod (Sales Method) — varchar(15)
  • saitem (Sales Item) — varchar(30)
  • saicode (Sales Item Code) — varchar(11)
  • sacount (Sales Item Count) — numeric(3)
  • saprice (Sales Item Price) — numeric(7)
  • sacp (Supply Price) — numeric(12)
  • savat (VAT Price) — numeric(12)
  • sasum (Total Amount) — numeric(15)

Spot (직위 테이블)

  • id (Spot id) — Auto Increment — Primary key — NOT NULL
  • spotcode (Spot Code) — int
  • spotname (Spot Name) — varchar(255)

Vacation_Apply (휴가 테이블)

  • id (ID) — Auto Increment — Primary key — NOT NULL
  • id (Employee id2) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Department id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Position id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • id (Spot id) — Auto Increment — Foreign key → Employee.id — NOT NULL
  • leavetype (Vacation Type) — varchar(255)
  • startdate (Vacation Start Date) — date
  • enddate (Vacation End Date) — date
  • period (Vacation Date) — long
  • employee_id (Employee id) — Auto Increment