newProject
Tables (4)
Reservation (Untitled4)
- id (Field) — varchar2(30) — Foreign key → member.id
- idx (Field3) — number(100) — Foreign key → ptClass.idx
member (Untitled)
- id (Field) — varchar2(30) — Primary key
- 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) — Primary key
- id (Field6) — varchar2(30) — Foreign key → member.id
- subject (Field2) — varchar2(100)
- content (Field3) — varchar2(3000)
- regDate (Field4) — timestamp
- clickCount (Field5) — number(20)
ptClass (Untitled2)
- idx (Field3) — number(100) — Primary key
- id (Field) — varchar2(30) — Foreign key → member.id
- ptTime (Field4) — date
- Check (Field5) — char(1)