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