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