own임니다
테이블 (36)
BAND
- BAND_NO — VARCHAR2(50)
- BAND_LEADERID — VARCHAR2(50)
- BAND_NAME — VARCHAR2(50)
- BAND_INTRO — VARCHAR2(500)
- BAND_KEYWORD — VARCHAR2(500)
- BAND_OPEN_OPTION — VARCHAR2(10)
- BAND_AGE_OPTION — VARCHAR2(10)
- BAND_AGE_BEFOROPTION — DATE
- BAND_AGE_AFTEROPTION — DATE
- BAND_CATEGORY — VARCHAR2(300)
- BAND_GENDER_OPTION — VARCHAR2(10)
- BAND_MEMBERSHIP_OPTION — VARCHAR2(10)
- BAND_LOCATION — VARCHAR2(100)
- BAND_GENDER — VARCHAR2(20)
- BAND_STATUS — VARCHAR2(50)
- BAND_DISABLETIME — DATE
BAND_BOARD_DETAIL
- BAND_BOARD_CONTENT — VARCHAR2(3000)
- BAND_BOARD_CNT — VARCHAR2(50)
- BAND_BOARD_DETAIL_NO — VARCHAR2(50)
- BAND_REMARKS — VARCHAR2(50)
- BAND_BOARD_DATE — DATE
- BAND_BOARD_UPDATE — DATE
- BAND_BOARD_TAG — VARCHAR2(500)
- BAND_BOARD_OPTION_NO — VARCHAR2(50)
- BAND_BOARD_TITLE — VARCHAR2(100)
- BAND_BOARD_WRITER — VARCHAR2(50)
BAND_BOARD_OPTION
- BAND_BOARD_ORDER — VARCHAR2(10)
- BAND_BOARD_NAME — VARCHAR2(50)
- BAND_BOARD_AUTH — VARCHAR2(10)
- BAND_LIKE_OPTION — VARCHAR2(10)
- BAND_CONTENT_OPTION — VARCHAR2(500)
- BAND_BOARD_REMARKS — VARCHAR2(500)
- BAND_BOARD_LINE — VARCHAR2(10)
- BAND_BOARD_OPTION_NO — VARCHAR2(50)
- BAND_NO — VARCHAR2(50)
BAND_CALENDAR
- BAND_CALENDAR_NO — VARCHAR2(50)
- BAND_BOARD_DETAIL_NO — VARCHAR2(50)
- BAND_CALENDAR_START — DATE
- BAND_CALENDAR_END — DATE
- BAND_CALENDAR_TITLE — VARCHAR2(50)
- BAND_CALENDAR_MARK — VARCHAR2(10)
- BAND_CALENDAR_LOCATION — VARCHAR2(50)
- BAND_CALENDAR_OPTION — VARCHAR2(25)
- BAND_CALENDAR_OPTION_DAY — DATE
- BAND_CALENDAR_OPTION_SHARE — VARCHAR2(25)
- BAND_CALENDAR_LOCATION_LATLONG — VARCHAR2(100)
- BAND_NO — VARCHAR2(50)
- USER_ID — VARCHAR2(50)
BAND_CALENDAR_DETAIL
- BAND_CALENDAR_NO — VARCHAR2(50)
- BAND_MEMBER_NO — VARCHAR2(50)
- BAND_ATTEND — VARCHAR2(10)
BAND_MEMBER_DEFAULT
- USER_ID — VARCHAR2(50)
- BAND_NICKNAME — VARCHAR2(50)
- BAND_GENDER — VARCHAR2(5)
- BAND_LOCATION — VARCHAR2(30)
- BAND_INTEREST — VARCHAR2(30)
- BAND_BIRTH — DATE
BAND_MEMBER_DETAIL
- USER_ID — VARCHAR2(50)
- BAND_NICKNAME — VARCHAR2(50)
- BAND_NO — VARCHAR2(50)
- BAND_MEMBER_STATUS — VARCHAR2(10)
- BAND_KICK_STATUS — VARCHAR2(10)
- BAND_SIGNUP_DATE — DATE
- BAND_ACCESS_DATE — DATE
- BAND_KICK_DATE — DATE
- BAND_MEMBER_NO — VARCHAR2(50)
- BAND_BIRTH — DATE
- BAND_GENDER — VARCHAR2(10)
- BAND_MEMBER_INTRO — VARCHAR2(300)
- BAND_MEMBER_REJOIN — VARCHAR2(10)
- BAND_MEMBER_KICK_REASON — VARCHAR2(300)
- BAND_MEMBER_GENDER_OPEN — VARCHAR2(10)
- BAND_MEMBER_BIRTH_OPEN — VARCHAR2(10)
- BAND_MEMBER_AGE_OPEN — VARCHAR2(10)
BAND_MEMBER_DETAIL_TEST
- USER_ID — VARCHAR2(50)
- BAND_NICKNAME — VARCHAR2(50)
- BAND_NO — VARCHAR2(50)
- BAND_MEMBER_STATUS — VARCHAR2(10)
- BAND_KICK_STATUS — VARCHAR2(10)
- BAND_SIGNUP_DATE — DATE
- BAND_ACCESS_DATE — DATE
- BAND_KICK_DATE — DATE
- BAND_MEMBER_NO — VARCHAR2(50)
- BAND_BIRTH — DATE
- BAND_GENDER — VARCHAR2(10)
- BAND_MEMBER_INTRO — VARCHAR2(300)
- BAND_MEMBER_REJOIN — VARCHAR2(10)
- BAND_MEMBER_KICK_REASON — VARCHAR2(300)
- BAND_MEMBER_GENDER_OPEN — VARCHAR2(10)
- BAND_MEMBER_BIRTH_OPEN — VARCHAR2(10)
- BAND_MEMBER_AGE_OPEN — VARCHAR2(10)
BAND_VOTE
- BAND_BOARD_DETAIL_NO — VARCHAR2(50)
- BAND_VOTE_TITLE — VARCHAR2(50)
- VOTE_NO1 — VARCHAR2(50)
- VOTE_NO2 — VARCHAR2(50)
- VOTE_NO3 — VARCHAR2(50)
- VOTE_NO4 — VARCHAR2(50)
- VOTE_NO5 — VARCHAR2(50)
- MULTI_OPTION — VARCHAR2(10)
- SECRET_OPTION — VARCHAR2(10)
- DEADLINE_OPTION — DATE
BAND_VOTE_DETAIL
- BAND_BOARD_DETAIL_NO — VARCHAR2(50)
- BAND_MEMBER_NO — VARCHAR2(50)
- BAND_VOTE_NO1 — VARCHAR2(5)
- BAND_VOTE_NO2 — VARCHAR2(5)
- BAND_VOTE_NO3 — VARCHAR2(5)
- BAND_VOTE_NO4 — VARCHAR2(5)
- BAND_VOTE_NO5 — VARCHAR2(5)
CHALLENGES
- CHALL_NO — VARCHAR2(10)
- CHALL_CATEGORY — VARCHAR2(50)
- CHALL_TAG — VARCHAR2(100)
- CHALL_TITLE — VARCHAR2(100)
- CHALL_DURATION — NUMBER(10,0)
- CHALL_FREQ — NUMBER(10,0)
- CHALL_STARTDATE — DATE
- NOW_MEM — NUMBER(10,0)
- CHALL_INTRO — VARCHAR2(1000)
- MAX_MEM — NUMBER(10,0)
- CHALL_PRICE — NUMBER(10,0)
- VLD_METHOD — VARCHAR2(300)
- CHALL_PWD — VARCHAR2(50)
- CHALL_STATUS — VARCHAR2(10)
- CHALL_LEADER — VARCHAR2(50)
- REST_PRICE — NUMBER(10,0)
CHALL_AMOUNT_LIST
- AMT_LIST_NO — VARCHAR2(10)
- USER_ID — VARCHAR2(50)
- AMT_TYPE — VARCHAR2(30)
- AMT_METHOD — VARCHAR2(30)
- PRICE — NUMBER(10,0)
- CHALL_NO — VARCHAR2(10)
- CHALL_AMOUNT_DATE — DATE
CHALL_MEMBER
- USER_ID — VARCHAR2(50)
- MEM_NICKNAME — VARCHAR2(50)
- MEM_AMT — NUMBER(10,0)
- MEM_ACC — NUMBER(20,0)
- MEM_BANK — VARCHAR2(20)
- MEM_INTRO — VARCHAR2(300)
- MEM_ACCNAME — VARCHAR2(50)
- MEM_NO — VARCHAR2(10)
CHALL_MEM_LIST
- USER_ID — VARCHAR2(50)
- MEM_STATUS — VARCHAR2(10)
- CHALL_NO — VARCHAR2(10)
- MEM_LIST_NO — VARCHAR2(10)
CHALL_PAY_REFUND
- PAY_REFUND_NO — VARCHAR2(10)
- PAY_CODE — VARCHAR2(10)
- PAY_DATE — DATE
- PAY_TYPE — VARCHAR2(50)
- REFUND_INFO — VARCHAR2(50)
- PRICE — NUMBER(10,0)
CHALL_REPORT
- REPORT_NO — VARCHAR2(50)
- REPORTER — VARCHAR2(50)
- REPORT_REASON — VARCHAR2(500)
- REPORT_DATE — DATE
- REPORT_STATE — VARCHAR2(50)
- VLD_NO — VARCHAR2(10)
CHALL_RESULT
- RESULT_NO — VARCHAR2(10)
- USER_ID — VARCHAR2(50)
- CHALL_NO — VARCHAR2(10)
- CHALL_VLD — NUMBER(10,0)
- MEM_VLD — NUMBER(10,0)
- SUCCESS_RATE — NUMBER
- REFUND_PRICE — NUMBER(10,0)
- REWARD_PRICE — NUMBER(10,0)
CHALL_VALIDATION
- VLD_NO — VARCHAR2(10)
- VLD_DATE — DATE
- VLD_STATUS — VARCHAR2(10)
- CHALL_NO — VARCHAR2(10)
- USER_ID — VARCHAR2(50)
CHATROOM
- CHATROOM_NO — VARCHAR2(50)
- CHATROOM_NAME — VARCHAR2(50)
- BAND_MEMBER_NO — VARCHAR2(50)
EMPLOYEES
- EMPLOYEE_ID — VARCHAR2(50)
EXER_RECORD
- USER_ID — VARCHAR2(50)
- EXEREC_DATE — DATE
- EXEREC_WEIGHT — NUMBER
- EXEREC_CONDITION — VARCHAR2(50)
- EXEREC_TIME — NUMBER
- EXEREC_METER — NUMBER
- EXEREC_ROUTIN — VARCHAR2(500)
- EXEREC_FEEDBACK — VARCHAR2(500)
- EXEREC_NO — VARCHAR2(50)
- EXERSUB_NO — VARCHAR2(50)
EXER_SUB
- EXERSUB_KIND — VARCHAR2(50)
- KCAL — NUMBER
- EXERSUB_NAME — VARCHAR2(50)
- EXERSUB_NO — VARCHAR2(50)
MESSAGE
- MESSAGE_NO — VARCHAR2(50)
- MESSAGE_CONTENT — VARCHAR2(500)
- MESSAGE_TIME — TIMESTAMP
- CHATROOM_NO — VARCHAR2(50)
- BAND_MEMBER_NO — VARCHAR2(50)
MULTIMEDIA
- MEDIA_NO — VARCHAR2(50)
- MEDIA_REAL_FILE — VARCHAR2(3000)
- MEDIA_SERVER_FILE — VARCHAR2(3000)
- MEDIA_FILE_PATH — VARCHAR2(3000)
- IDENTIFY_ID — VARCHAR2(50)
- MEDIA_CATEGORY — VARCHAR2(50)
- MEDIA_TURN — CHAR(18)
OWN_LIKE
- CATEGORY_NO — VARCHAR2(50)
- USER_ID — VARCHAR2(50)
- CATEGORY — VARCHAR2(50)
- LIKE_NO — CHAR(18)
OWN_LOCATION
- LOC_CODE — VARCHAR2(30)
- LOC_CITY — VARCHAR2(50)
OWN_USERS
- USER_ID — VARCHAR2(50)
- USER_PASSWD — VARCHAR2(100)
- USER_NAME — VARCHAR2(50)
- USER_EMAIL — VARCHAR2(30)
- USER_PHONE — VARCHAR2(20)
- USER_BIRTHDAY — DATE
- USER_GENDER — VARCHAR2(10)
- USER_PERM — VARCHAR2(20)
- USER_STATUS — VARCHAR2(10)
- USER_HOBBY — VARCHAR2(500)
- SNS_ACCOUNT_NO — VARCHAR2(50)
- OWN_USERS_NO — VARCHAR2(50)
QUESTION
- QUEST_NO — VARCHAR2(50)
- USER_ID — VARCHAR2(50)
- TITLE — VARCHAR2(50)
- CONTENT — VARCHAR2(500)
- ANSWER — VARCHAR2(500)
- QUEST_DATE — DATE
- HEADER — VARCHAR2(50)
- STATUS — VARCHAR2(30)
REPLY
- REPLY_NO — VARCHAR2(50)
- REPLY_CONTENT — VARCHAR2(500)
- REPLY_DATE — DATE
- USER_ID — VARCHAR2(50)
- REPLY_LIKE — NUMBER
- CATEGORY_NO — VARCHAR2(50)
REPORT
- REPORT_NO — VARCHAR2(50)
- REPORTER — VARCHAR2(50)
- DEREPORTER — VARCHAR2(50)
- REASON — VARCHAR2(50)
- CONTENT — VARCHAR2(500)
- REPORT_DATE — DATE
- STATUS — VARCHAR2(50)
RE_REPLY
- RE_REPLY_NO — VARCHAR2(50)
- RE_REPLY_DATE — DATE
- RE_REPLY_CONTENT — VARCHAR2(500)
- USER_ID — VARCHAR2(50)
- REPLY_NO — VARCHAR2(50)
SNS_ACCOUNT
- SNS_NICKNAME — VARCHAR2(100)
- SNS_PROFILE — VARCHAR2(500)
- SNS_WEBSITE — VARCHAR2(50)
- SNS_ACCOUNT_NO — VARCHAR2(50)
SNS_BOARD
- SNS_BOARD_NO — VARCHAR2(50)
- SNS_BOARD_CONTENT — VARCHAR2(1600)
- SNS_BOARD_DATE — DATE
- SNS_NICKNAME — VARCHAR2(100)
- SNS_ACCOUNT_NO — VARCHAR2(50)
SNS_FOLLOW
- SNS_FOLLOW_ID — VARCHAR2(50)
- SNS_FOLLOWER_ID — VARCHAR2(50)
- SNS_FOLLOW_NO — VARCHAR2(50)
SNS_HIGHLIGHT
- SNS_HIGHLIGHT_NO — VARCHAR2(50)
- SNS_STORY_NO — VARCHAR2(50)
SNS_STORY
- SNS_STORY_NO — VARCHAR2(50)
- SNS_NICKNAME — VARCHAR2(50)
- SNS_STORY_DATE — DATE
- SNS_STATUS — VARCHAR2(10)
- SNS_ACCOUNT_NO — VARCHAR2(50)