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)