오운

테이블 (7)

밴드 (BAND)

  • 밴드식별번호 (BAND_NO) — VARCHAR2(50)
  • 밴드장ID (BAND_LEADER) — VARCHAR2(50)
  • 밴드명 (BAND_NAME) — VARCHAR2(50)
  • 밴드소개 (BAND_INTRO) — VARCHAR2(100)
  • 밴드키워드 (BAND_KEYWORD) — VARCHAR2(500)
  • 밴드공개유무 (BAND_OPEN_OPTION) — VARCHAR2(10)
  • 지역설정 (BAND_LOCATION) — VARCHAR2(100)
  • 성별 (BAND_GENDER) — VARCHAR2(20)
  • 연령제한1 (BAND_AGE_BEFOROPTION) — DATE
  • 연령제한2 (BAND_AGE_AFTEROPTION) — DATE
  • 카테고리 (BAND_CATEGORY) — VARCHAR2(300)
  • 성별제한 (BAND_GENDER_OPTION) — VARCHAR2(10)
  • 가입제한 (BAND_MEMBESHIP_OPTION) — VARCHAR2(10)
  • 연령제한옵션 (BAND_AGE_OPTION) — VARCHAR2(10)
  • 밴드휴면상태 (BAND_STATUS) — VARCHAR2(10)
  • 밴드휴면시작시간 (BAND_DISABLETIME) — DATE

밴드 게시글 (Untitled3)

    밴드 게시판 설정 (Untitled4)

      밴드게시글 일정 (Untitled6)

        밴드게시판설정 (Untitled5)

          밴드디폴트 멤버설정 (BAND_MEMBER_DEFAULT)

          • USER_ID (회원ID) — VARCHAR2
          • BAND_NICKNAME (멤버닉네임) — VARCHAR2
          • BAND_GENDER (멤버성별) — VARCHAR2
          • BAND_LOCATION (멤버관심지역) — VARCHAR2
          • BAND_INTEREST (멤버관심분야) — VARCHAR2
          • BAND_BIRTH (멤버생년월일)

          밴드멤버 (BAND_MEMBER)

          • USER_ID (회원ID) — VARCHAR2
          • BAND_NICKNAME (닉네임) — VARCHAR2
          • BAND_NO (밴드번호) — VARCHAR2
          • BAND_MEMBER_STATUS (밴드가입상태) — VARCHAR2
          • BAND_KICK_STATUS (밴드강퇴상태) — VARCHAR2
          • BAND_SIGNUP_DATE (밴드가입날짜) — DATE
          • BAND_ACCESS_DATE (밴드승인날짜) — DATE
          • BAND_KICK_DATE (밴드강퇴날짜) — DATE
          • BAND_MEMBER_NO (밴드멤버번호) — VARCHAR2
          • BAND_BIRTH (멤버생일) — DATE
          • BAND_GENDER (Field)