2차프로잭트 최종
테이블 (13)
FACILITY
- FACILITY_IDX — NUMBER(10) — 기본 키
- FACILITY_NAME — VARCHAR2(100)
- ADDRESS — VARCHAR2(100)
- PHONE_NUMBER — VARCHAR2(20)
- EVENT — VARCHAR2(100)
- THUMB — VARCHAR2(200)
- THUMB_PI — VARCHAR2(100)
- IMAGE_IDX — NUMBER(10)
- OPEN_TIME — NUMBER(3)
- CLOSE_TIME — NUMBER(3)
- CAPACITY — NUMBER(10)
- DATE_RANGE_FOR_RESERVATION — NUMBER(3)
FACILITY_RESERVE
- RESERVE_IDX — NUMBER(10) — 기본 키
- USERIDX — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- FACILITY_IDX — NUMBER(10) — 외래 키 → FACILITY.FACILITY_IDX
- RESERVE_DATE — VARCHAR2(20)
- RESERVE_TIME — VARCHAR2(20)
- HEAD_COUNT — NUMBER(3)
FREE_BBS
- BBS_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- SUBJECT — VARCHAR2(1000)
- CONTENT — VARCHAR2(3000)
- WRITE_DATE — DATE
- IMAGE_IDX — NUMBER(10)
- HIT — NUMBER(10)
FREE_COMMENTS
- COMMENT_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- BBS_IDX (BBS_IDX3) — NUMBER(10) — 외래 키 → FREE_BBS.BBS_IDX
- BBS_IDX — NUMBER(10)
- CONTENT — VARCHAR2(1000)
- WRITE_DATE — DATE
- BBS_IDX (BBS_IDX2) — NUMBER(10)
IMAGES
- IMAGE_IDX — NUMBER(10)
- IMAGE — VARCHAR2(100)
- IMAGE_PI — VARCHAR2(100)
JOIN_BBS
- BBS_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- TEAM_IDX — NUMBER(10)
- SUBJECT — VARCHAR2(1000)
- TIME — VARCHAR2(1000)
- MEMBER_MAX — VARCHAR2(1000)
- LIMIT — VARCHAR2(1000)
- PLACE — VARCHAR2(1000)
- EVENT — VARCHAR2(1000)
- CONTENT — VARCHAR2(3000)
- WRITE_DATE — DATE
- IMAGE_IDX — NUMBER(10)
- TEAM_NAME — VARCHAR2(100)
- HIT — NUMBER(10)
JOIN_COMMENTS
- COMMENT_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- BBS_IDX (BBS_IDX2) — NUMBER(10) — 외래 키 → JOIN_BBS.BBS_IDX
- CONTENT — VARCHAR2(1000)
- WRITE_DATE — DATE
SPORT_USER
- USERIDX — NUMBER(10) — 기본 키
- EMAIL — VARCHAR2(30)
- NICKNAME — VARCHAR2(30)
- PASSWORD — VARCHAR2(30)
- PHONE — VARCHAR2(20)
- GENDER — VARCHAR2(10)
- IMAGE — VARCHAR2(200)
- IMAGE_PI — VARCHAR2(100)
- JOIN_DATE — DATE
- LEAVE_DATE — DATE
- MANAGER — VARCHAR2(10)
- INTRODUCE — VARCHAR2(1000)
TEAMS
- TEAM_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- USERIDX — NUMBER(10)
- JOIN_CHECK — VARCHAR2(10)
- TEAM_NAME — VARCHAR2(100)
- LOGO — VARCHAR2(200)
- LOGO_PI — VARCHAR2(100)
- START_DATE — DATE
- END_DATE — DATE
TEAM_BBS
- BBS_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- TEAM_IDX (TEAM_IDX2) — NUMBER(10) — 외래 키 → TEAMS.TEAM_IDX
- SUBJECT — VARCHAR2(1000)
- CONTENT — VARCHAR2(3000)
- WRITE_DATE — DATE
- IMAGE_IDX — NUMBER(10)
- HIT — NUMBER(10)
TEAM_COMMENTS
- COMMENT_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- BBS_IDX (BBS_IDX2) — NUMBER(10) — 외래 키 → TEAM_BBS.BBS_IDX
- CONTENT — VARCHAR2(1000)
- WRITE_DATE — DATE
TEAM_MEMBER
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → TEAM_SIGNUP.USERIDX
- TEAM_IDX (TEAM_IDX2) — NUMBER(10) — 외래 키 → TEAMS.TEAM_IDX
- JOIN_DATE — DATE
- LEAVE_DATE — DATE
- TEAM_MANAGER — VARCHAR2(10)
TEAM_SIGNUP
- SIGNUP_IDX — NUMBER(10) — 기본 키
- USERIDX (USERIDX2) — NUMBER(10) — 외래 키 → SPORT_USER.USERIDX
- TEAM_IDX — REFERENCES
- USERIDX — NUMBER(10)
- CONTENT — VARCHAR2(1000)
- SIGNUP_CHECK — VARCHAR2(1)
- SIGNUP_DATE — DATE