hair
Tables (20)
admin (관리자)
- adminId (Key) — varchar2(20) — Primary key — NOT NULL
- pw (Field) — varchar2(100)
board (게시판)
- boardSeq (Key) — number — Primary key — NOT NULL
- memberId (Key2) — varchar2(100) — Foreign key → member.memberId — NOT NULL
- title (Field) — varchar2(200)
- content (Field2) — varchar2(2000)
- date (Field3) — date
career (경력)
- careerSeq (Key) — number — Primary key — NOT NULL
- employSeq (Key2) — number — Foreign key → employee.employeeId — NOT NULL
- date (Field) — date
- content (Field2) — varchar2(2000)
chat (채팅)
- chatSeq (Key) — number — Primary key — NOT NULL
- memberId (Key2) — varchar2(100) — Foreign key → member.memberId — NOT NULL
- content (Field) — varchar2(2000)
- date (Field2) — date
employee (직원)
- employeeId (Key) — varchar2(100) — Primary key — NOT NULL
- positionSeq (Key2) — number — Foreign key → position.positionSeq — NOT NULL
- name (Field) — varchar2(10)
- hireDate (Field2) — date
- birthDate (Field3) — date
- phone (Field4) — varchar2(100)
- address (Field5) — varchar2(200)
- fireDate (Field6) — date
hair (머리종류)
- hairSeq (Key) — number — Primary key — NOT NULL
- style (Field) — varchar2(200)
- kind (Field2) — varchar2(50)
hairColor (머리색)
- colorSeq (Key) — number — Primary key — NOT NULL
- color (Field) — varchar2(50)
- colorCode (Field2) — varchar2(50)
member (회원)
- memberId (Key) — varchar2(100) — Primary key — NOT NULL
- pw (Field) — varchar2(100)
- money (Field2) — number
- phone (Field3) — varchar2(50)
- birthday (Field4) — date
- name (Field5) — varchar2(50)
- registDate (Field6) — date
notice (공지)
- noticeSeq (Key) — number — Primary key — NOT NULL
- adminId (Key2) — varchar2(20) — Foreign key → admin.adminId — NOT NULL
- title (Field) — varchar2(200)
- content (Field2) — varchar2(2000)
- date (Field3) — date
offSchedule (오프일정)
- schedulSeq (Key) — Primary key — NOT NULL
- employeeId (Key2) — varchar2(100) — Foreign key → employee.employeeId — NOT NULL
- startDate (Field) — date
- endDate (Field2) — date
- check (Field3) — varchar2(10)
payment (결제관리)
- paySeq (Key) — number — Primary key — NOT NULL
- price (Field) — number
- payStatus (Field2) — varchar2(10)
- date (Field3) — date
position (직책)
- positionSeq (Key) — number — Primary key — NOT NULL
- position (Field) — varchar2(10)
- salary (Field2) — number
procedure (시술종류)
- procedureSeq (Key) — number — Primary key — NOT NULL
- procedureName (Field) — varchar2(200)
- time (Field2)
procedureInformation (시술정보)
- reservationSeq (Key) — number — Foreign key → reservation.reservationSeq — NOT NULL
- procedureSeq (Key2) — number — Foreign key → procedure.procedureSeq — NOT NULL
- paySeq (Key4) — number — Foreign key → reservation.paySeq — NOT NULL
- sale (Field) — number
reservation (예약)
- reservationSeq (Key) — number — Primary key — NOT NULL
- employeeId (Key2) — varchar2(100) — Foreign key → employee.employeeId — NOT NULL
- memberId (Key3) — varchar2(100) — Foreign key → member.memberId — NOT NULL
- colorSeq (Key5) — number — Foreign key → hairColor.colorSeq — NOT NULL
- paySeq (Key4) — number — Foreign key → payment.paySeq — NOT NULL
- date (Field) — date
- time (Field2) — varchar2(100)
review (댓글)
- reviewSeq (Key) — number — Primary key — NOT NULL
- boardSeq (Key2) — number — Foreign key → board.boardSeq — NOT NULL
- memberId (Key3) — varchar2(100) — Foreign key → member.memberId — NOT NULL
- content (Field) — varchar2(500)
- date (Field2) — date
sale (상품목록)
- saleSeq (Key) — number — Primary key — NOT NULL
- name (Field) — varchar2(50)
- amount (Field2) — number
- price (Field3) — number
schedule (근무일정)
- schedulSeq (Key) — number — Primary key — NOT NULL
- employeeId (Key2) — varchar2(100) — Foreign key → employee.employeeId — NOT NULL
- time (Field) — varchar2(100)
- start (Field2) — date
- end (Field3) — date
supply (소모품)
- supplySeq (Key) — number — Primary key — NOT NULL
- employSeq (Key2) — number — Foreign key → employee.employeeId — NOT NULL
- name (Field) — varchar2(30)
- amount (Field2) — number
trade (거래관리)
- billSeq (Key) — number — Primary key — NOT NULL
- memberId (Key2) — varchar2(100) — Foreign key → member.memberId — NOT NULL
- saleSeq (Key3) — number — Foreign key → sale.saleSeq — NOT NULL