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