health
Tables (7)
APPLY (Untitled6)
- APPLYNUM (Key) — NUMBER — Primary key — NOT NULL
- MEMBERSHIPNUM (Key2) — MEMBERSHIP_SEQ — Foreign key → MEMBERSHIP.MEMBERSHIPNUM — NOT NULL — NUMBER SEQ
- TRANUM (Key3) — NUMBER — Foreign key → TRAINER.TRANUM — NOT NULL
- DAY (Field) — DATE
- TIME (Field2) — VARCHAR2(100)
EXERCISE (CopyOfCopyOfUntitled2)
- NUM (Key) — NUMBER — Primary key — NOT NULL
- TITLE (Field) — VARCHAR2(100)
- CONTENTS (Field2) — VARCHAR2(300)
- WRITER (Field3) — VARCHAR2(100)
- REGDATE (Field4) — DATE
- HIT (Field5) — NUMBER
GYMMEMBER (MEMBER)
- MEMBERNUM (NUM) — NUMBER — Primary key — NOT NULL — MEMBER_SEQ
- ID (Field2) — VARCHAR2(100)
- PW — VARCHAR2(100) — NOT NULL — NOTNULL,8~12자릿수
- NAME — VARCHAR2(100) — NOT NULL — not null
- PHONE — VARCHAR2(100) — NOT NULL — UNIQUE, NOT NULL
- GRADE (Field) — NUMBER
GYMNOTICE (CopyOfUntitled2)
- NUM (Key) — NUMBER — Primary key — NOT NULL
- TITLE (Field) — VARCHAR2(100)
- CONTENTS (Field2) — VARCHAR2(300)
- WRITER (Field3) — VARCHAR2(100)
- REGDATE (Field4) — DATE
- HIT (Field5) — NUMBER
GYMQNA (Untitled2)
- NUM (Key) — NUMBER — Primary key — NOT NULL
- TITLE (Field) — VARCHAR2(100)
- CONTENTS (Field2) — VARCHAR2(300)
- WRITER (Field3) — VARCHAR2(100)
- REGDATE (Field4) — DATE
- HIT (Field5) — NUMBER
- REF (Field6) — NUMBER
- STEP (Field7) — NUMBER
- DEPTH (Field8) — NUMBER
MEMBERSHIP (Untitled)
- MEMBERSHIPNUM (Key) — MEMBERSHIP_SEQ — Primary key — NOT NULL — NUMBER SEQ
- MEMBERNUM (NUM2) — NUMBER — Foreign key → GYMMEMBER.MEMBERNUM — NOT NULL — MEMBER_SEQ
- TRANUM (Key2) — NUMBER — Foreign key → TRAINER.TRANUM — NOT NULL
- COUNT (Field) — NUMBER
- PRICE (Field2) — NUMBER
- LOCKER (Field3) — NUMBER
- CLOTHES (Field4) — NUMBER
- STARTDATE (Field5) — DATE
- FINISHDATE (Field6) — DATE
TRAINER (Untitled7)
- TRANUM (Key) — NUMBER — Primary key — NOT NULL
- MEMBERNUM (NUM) — NUMBER — Foreign key → GYMMEMBER.MEMBERNUM — NOT NULL — MEMBER_SEQ
- PRICE (Field) — VARCHAR2(00)