baseball

테이블 (5)

구장 (stadium)

  • stadium_id (Key) — 기본 키 — NOT NULL
  • match_id (Key2) — 외래 키 → 매치.match_id — NOT NULL
  • book_code (Key22) — 외래 키 → 매치.book_code — NOT NULL
  • stadium_id (Key3) — 외래 키 → 매치.stadium_id — NOT NULL
  • member_id (Key222) — 외래 키 → 매치.member_id — NOT NULL
  • team_name (Key4) — 외래 키 → 매치.team_name — NOT NULL
  • stadium_totalseat (Field3)
  • stadium_name (Field)
  • stadium_location (Field2)
  • stadium_contact (Field4)
  • stadium_operationT (Field5)
  • stadium_entranceInfo (Field6)
  • stadium_price (Field7)
  • Field8

매치 (match)

  • match_id (Key) — 기본 키 — NOT NULL
  • book_code (Key2) — 외래 키 → 예매.book_code — NOT NULL
  • stadium_id (Key3) — 외래 키 → 예매.stadium_id — NOT NULL
  • member_id (Key22) — 외래 키 → 예매.member_id — NOT NULL
  • match_id (Key222) — 외래 키 → 예매.match_id — NOT NULL
  • book_code (Key2222) — 외래 키 → 예매.book_code — NOT NULL
  • stadium_id (Key32) — 외래 키 → 예매.stadium_id — NOT NULL
  • member_id (Key22222) — 외래 키 → 예매.member_id — NOT NULL
  • team_name (Key4) — 외래 키 → 팀.team_name — NOT NULL
  • match_schedule (Field)
  • match_record (Field2)
  • match_preview (Field3)
  • match_cancel (Field4)

예매 (book)

  • book_code — 기본 키 — NOT NULL
  • stadium_id — 외래 키 → 구장.stadium_id — NOT NULL
  • member_id (Key2) — 외래 키 → 회원.member_id — NOT NULL
  • match_id (Key22) — 외래 키 → 구장.match_id — NOT NULL
  • book_code (Key222) — 외래 키 → 구장.book_code — NOT NULL
  • stadium_id (Key32) — 외래 키 → 구장.stadium_id — NOT NULL
  • member_id (Key2222) — 외래 키 → 구장.member_id — NOT NULL
  • team_name (Key4) — 외래 키 → 구장.team_name — NOT NULL
  • book_state (Field2)
  • book_creation (Field)
  • book_update (Field3)
  • book_cancel (Field4)
  • book_matchInfo (Field5)
  • book_attend (Field6)
  • book_level (Field7)
  • book_category (Field8)

팀 (teams)

  • team_name (Key) — 기본 키 — NOT NULL

회원 (member)

  • member_id (Key) — 기본 키 — NOT NULL
  • member_pw (Field)
  • member_nick (Field2)
  • member_contact (Field3)
  • member_birth (Field4)
  • member_join (Field5)
  • member_lastlogin (Field6)
  • member_email (Field7)