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