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