test2
테이블 (8)
공장 (FACTORY)
- 공장아이디 (FAC_ID) — INT
- 직원이름 (name) — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- company_id — INT
급여 (SALARY)
- id — INT
- employee_id — INT
- amount — DECIMAL(10,2) — NOT NULL
- pay_date — DATE — NOT NULL
빵 (BREAD)
- id — INT
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
재고 (STOCK)
- id — INT
- bread_id — INT
- factory_id — INT
- branch_id — INT
- quantity — INT — NOT NULL
지점 (BRANCHES)
- id — INT
- name — VARCHAR(255) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- company_id — INT
직원 (EMPLOYEE)
- id — INT
- name — VARCHAR(255) — NOT NULL
- role — ENUM('사원', '매니저', '점장') — NOT NULL
- salary — DECIMAL(10,2) — NOT NULL
- branch_id — INT
- factory_id — INT
판매 (SALES)
- id — INT
- branch_id — INT
- bread_id — INT
- quantity_sold — INT — NOT NULL
- sale_date — DATE — NOT NULL
회사 (BREADCO)
- id — INT
- name — VARCHAR(255) — NOT NULL