회원게시판
테이블 (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)