회원게시판

테이블 (5)

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)

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)

게시판 (BOARD)

  • 글번호 (no) — NUMBER(4) — 기본 키 — NOT NULL
  • 제목 (subject) — VARCHAR2(200) — NOT NULL
  • 내용 (contesnt) — VARCHAR2(2000)
  • 작성일 (cre_date) — TIMESTAMP

회원 (MEMBER)

  • 회원번호 (member_id) — NUMBER(6) — 기본 키 — 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)