PTReserve

Tables (6)

PTmember (Untitled)

  • m_id (varchar(16)) — Primary key — NOT NULL
  • m_pw (varchar(20))
  • m_name (varchar(10))
  • m_phone (int(11)) — "000-0000-0000"
  • m_email (varchar(50))
  • master (number)

PTnotice (Untitled5)

  • noticeNo (int(5)) — Primary key — NOT NULL
  • noticeSubject (varchar(200))
  • noticeContent (varchar(1000))
  • noticeDate (date) — "0000/00/00"

PTpay (Untitled3)

  • reserveTime (date) — "0000/00/00/00" — Foreign key → PTreserve.reserveTime — NOT NULL
  • m_id (varchar(16)) — Foreign key → PTreserve.m_id — NOT NULL
  • trainerNo (int(3)) — Foreign key → PTreserve.trainerNo — NOT NULL
  • trainerName (varchar(10)) — Foreign key → PTreserve.trainerName — NOT NULL
  • payCard (int(20))
  • payTotal (int(10))

PTreserve (Untitled2)

  • reserveTime (date) — "0000/00/00/00" — Primary key — NOT NULL
  • m_id (varchar(16)) — Foreign key → PTmember.m_id — NOT NULL
  • trainerNo (int(3)) — Foreign key → PTtrainer.trainerNo — NOT NULL
  • trainerName (varchar(10)) — Foreign key → PTtrainer.trainerName — NOT NULL
  • reserveNo (int(10))

PTreview (Untitled6)

  • boardNo (int(4)) — Primary key — NOT NULL
  • m_id (varchar(16)) — Foreign key → PTmember.m_id — NOT NULL
  • boardContent (varchar(1000))
  • review (varchar(500))

PTtrainer (Untitled4)

  • trainerNo (int(3)) — Primary key — NOT NULL
  • trainerName (varchar(10)) — Primary key — NOT NULL
  • trainerPhone (int(11)) — "000-0000-0000"
  • trainerSchedule (date) — "0000/00/00/00"