acornfianl
Tables (12)
attendance (근태기록)
- attendance_id (Key) — Primary key — NOT NULL — 근태번호
- employee_id (Key2) — Foreign key → employee.employee_id — NOT NULL — 직원번호
board (게시판)
- board_id (Key) — Primary key — NOT NULL — 게시글ID
- employee_id (Key2) — Foreign key → employee.employee_id — NOT NULL — 직원번호
employee (직원정보)
- employee_id (Key) — Primary key — NOT NULL — 직원번호
member (고객관리)
- member_id (Key) — Primary key — NOT NULL — 회원번호
notice (공지사항)
- notice_id (Key) — Primary key — NOT NULL — 공지ID
- employee_id (Key2) — Foreign key → employee.employee_id — NOT NULL — 직원번호
product (상품)
- product_id (Key) — Primary key — NOT NULL — 상품번호
reservation (예약)
- reservation_id (Key) — Primary key — NOT NULL — 예약번호
- member_id (Key2) — Foreign key → member.member_id — NOT NULL — 회원번호
- employee_id (Key3) — Foreign key → employee.employee_id — NOT NULL — 직원번호
- service_id (Key4) — Foreign key → service.service_id — NOT NULL — 서비스ID
salary (급여관리)
- salary_id (Key) — Primary key — NOT NULL — 급여ID
- employee_id (Key2) — Foreign key → employee.employee_id — NOT NULL — 직원번호
sales (매출관리)
- sales_id (Key) — Primary key — NOT NULL — 매출ID
- member_id (Key2) — Foreign key → member.member_id — NOT NULL — 회원번호
- employee_id (Key3) — Foreign key → employee.employee_id — NOT NULL — 직원번호
sales_detail (판매상세)
- detail_id (Key) — Primary key — NOT NULL — 상세ID
- sales_id (Key2) — Foreign key → sales.sales_id — NOT NULL — 매출ID
schedule (직원 스케줄)
- schedule_id (Key) — Primary key — NOT NULL — 스케줄ID
- employee_id (Key2) — Foreign key → employee.employee_id — NOT NULL — 직원번호
service (서비스)
- service_id (Key) — Primary key — NOT NULL — 서비스ID