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)