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