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"