11

Tables (3)

Counseling (Untitled2)

  • ID (Key) — INT — Primary key — NOT NULL
  • date (Field) — DATE
  • time (Field2) — TIMESTAMP
  • branch (Field3) — VARCHAR(45)
  • employeeID (Field4) — INT
  • customerID (Field5) — INT
  • Field6
  • ID (Key2) — INT — Foreign key → Customer.ID — NOT NULL
  • employeeID (Key3) — INT — Foreign key → Employee.employeeID — NOT NULL

Customer (Untitled)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(20)
  • telephone (Field2) — VARCHAR(45)
  • personalnumber (Field3) — VARCHAR(45)
  • branch (Field4) — VARCHAR(45)
  • selectedDate (Field5) — DATE
  • selectedTime (Field6) — varchar(45)
  • memo (Field7) — varchar(100)

Employee (Untitled3)

  • employeeID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(20)
  • complimentIndex (Field2) — INT
  • password (Field3) — VARCHAR(45)
  • score (Field4) — INT
  • Field5