회원게시판

테이블 (6)

PLAYER

  • PLAYER_ID — CHAR(7) — 기본 키 — NOT NULL
  • PLAYER_NAME — VARCHAR2(20) — NOT NULL
  • TEAM_ID — CHAR(3) — NOT NULL
  • E_PLAYER_NAME — VARCHAR2(40)
  • NICKNAME — VARCHAR2(30)
  • JOIN_YYYY — CHAR(4)
  • POSITION — VARCHAR2(10)
  • BACK_NO — NUMBER(2)
  • NATION — VARCHAR2(20)
  • BIRTH_DATE — DATE
  • SOLAR — CHAR(1)
  • HEIGHT — NUMBER(3)
  • WEIGHT — NUMBER(3)

SCHEDULE

  • STADIUM_ID — CHAR(3) — 기본 키 — NOT NULL
  • SCHE_DATE — CHAR(8) — 기본 키 — NOT NULL
  • GUBUN — CHAR(1) — NOT NULL
  • HOMETEAM_ID — CHAR(3) — NOT NULL
  • AWAYTEAM_ID — CHAR(3) — NOT NULL
  • HOME_SCORE — NUMBER(2)
  • AWAY_SCORE — NUMBER(2)

STADIUM

  • STADIUM_ID — CHAR(3) — 기본 키 — NOT NULL
  • STADIUM_NAME — VARCHAR2(40) — NOT NULL
  • HOMETEAM_ID — CHAR(3)
  • SEAT_COUNT — NUMBER
  • ADDRESS — VARCHAR2(60)
  • DDD — VARCHAR2(3)
  • TEL — VARCHAR2(10)

TEAM

  • TEAM_ID — CHAR(3) — 기본 키 — NOT NULL
  • REGION_NAME — VARCHAR2(8) — NOT NULL
  • TEAM_NAME — VARCHAR2(40) — NOT NULL
  • E_TEAM_NAME — VARCHAR2(50)
  • ORIG_YYYY — CHAR(4)
  • STADIUM_ID — CHAR(3) — NOT NULL
  • ZIP_CODE1 — CHAR(3)
  • ZIP_CODE2 — CHAR(3)
  • ADDRESS — VARCHAR2(80)
  • DDD — VARCHAR2(3)
  • TEL — VARCHAR2(10)
  • FAX — VARCHAR2(10)
  • HOMEPAGE — VARCHAR2(50)
  • OWNER — VARCHAR2(10)

게시판 (Untitled2)

  • 글번호 (NO) — NUMBER(4) — 기본 키 — NOT NULL
  • 제목 (SUBJECT) — VARCHAR2(200) — NOT NULL
  • 내용 (CONTENT) — VARCHAR2(2000)
  • 작성일 (CRE_DATE) — TIMESTAMP(0
  • 회원 (member_id) — NUMBER(8) — 외래 키 → 회원.회원 — NOT NULL

회원 (Untitled)

  • 회원 (member_id) — NUMBER(8) — 기본 키 — NOT NULL
  • 회원이름 (member_name) — VARCHAR2(20) — NOT NULL
  • 암호 (passwd) — VARCHAR2(10) — NOT NULL
  • 성별 (GENDER) — CHAR(3)
  • 전화번호 (PHONE_NO) — VARCHAR2(13)
  • 주소 (ADDRESS) — VARCHAR2(50)
  • 가입일 (JOIN_DATE) — DATE
  • 관심분야 (INTEREST) — VARCHAR2(15)