오운
테이블 (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
밴드디폴트 멤버설정 (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)