2차프로젝트 최종

테이블 (4)

Reservation (Untitled4)

  • id (Field) — varchar2(30) — 외래 키 → member.id
  • idx (Field3) — number(100) — 외래 키 → ptClass.idx

member (Untitled)

  • id (Field) — varchar2(30) — 기본 키
  • password (Field2) — varchar2(50)
  • name (Field3) — varchar2(30)
  • postCode (Field4) — varchar2(100)
  • addr1 (Field5) — varchar2(100)
  • addr2 (Field6) — varchar2(100)
  • email (Field7) — varchar2(50)
  • gender (Field8) — char(1)
  • ptCount (Field9) — number(3)
  • startDay (Field10) — date
  • endDay (Field11) — date
  • lev (Field12) — number(2)
  • myTrainer (Field13) — varchar2(30)

notice (Untitled3)

  • idx (Field) — number(10) — 기본 키
  • id (Field6) — varchar2(30) — 외래 키 → member.id
  • subject (Field2) — varchar2(100)
  • content (Field3) — varchar2(3000)
  • regDate (Field4) — timestamp
  • clickCount (Field5) — number(20)

ptClass (Untitled2)

  • idx (Field3) — number(100) — 기본 키
  • id (Field) — varchar2(30) — 외래 키 → member.id
  • ptTime (Field4) — date
  • Check (Field5) — char(1)