예약

테이블 (8)

경기결과 (Untitled4)

  • memberName (Key22) — VARCHAR2 — 외래 키 → 경기상세정보.memberName — NOT NULL
  • gameNumber (Key3) — NUMBER — 외래 키 → 경기상세정보.gameNumber — NOT NULL
  • highdistance (Field2) — NUMBER
  • Field3 — NUMBER
  • homerun (Field4) — NUMBER

경기상세정보 (Untitled3)

  • memberName (Key2) — VARCHAR2 — 기본 키 — NOT NULL
  • gameNumber (Key) — NUMBER — 외래 키 → 경기정보.gameNumber — NOT NULL
  • homeAway (Field) — VARCHAR2
  • battingOrder (Field2) — NUMBER
  • difficulty (Field3) — VARCHAR2

경기정보 (Untitled2)

  • gameNumber (Key) — NUMBER — 기본 키 — NOT NULL
  • memberCount (Field) — NUMBER
  • team (Field2) — VARCHAR2
  • inning (Field3) — NUMBER
  • Field4

비회원예약 (CopyOfUntitled)

  • reservationId (Key) — NUMBER — 기본 키 — NOT NULL
  • gameNumber (Key3) — NUMBER — 외래 키 → 경기정보.gameNumber — NOT NULL
  • gameTime (Field2) — NUMBER
  • reservationTime (Field3) — DATE
  • roomNumber (Field4) — NUMBER
  • reservationStatus (Field6) — VARCHAR2
  • nonuserName (Field) — VARCHAR2
  • nonuserPhone (Field5) — NUMBER

온라인결제 (Untitled5)

  • reservationId (Key) — NUMBER — 외래 키 → 비회원예약.reservationId — NOT NULL
  • gameNumber (Key3) — NUMBER — 외래 키 → 비회원예약.gameNumber — NOT NULL
  • payCode (Field2) — VARCHAR2
  • payMethod (Field) — VARCHAR2
  • payDate (Field3) — DATE
  • payAmount (Field4) — NUMBER

현장결제 (Untitled6)

  • Field
  • Field2

회원예약 (Untitled)

  • reservationId (Key) — NUMBER — 기본 키 — NOT NULL
  • gameNumber (Key2) — NUMBER — 기본 키 — NOT NULL
  • userId (Key3) — VARCHAR2 — 외래 키 → 회원테이블.userId — NOT NULL
  • gameTime (Field2) — NUMBER
  • reservationTime (Field3) — DATE
  • roomNumber (Field4) — NUMBER
  • reservationStatus (Field6) — VARCHAR2

회원테이블 (..)

  • userId (Key) — 기본 키 — NOT NULL
  • userPassword (Field)
  • userName (Field2)
  • userPhone (Field3)
  • userRole (Field4)
  • userNickname (Field5)