Shoong

Tables (30)

ADMIN_

  • ID — varchar2(30) — Primary key — NOT NULL
  • PWD — varchar2(20)
  • NAME — nvarchar2(10)
  • JOBCODE — nvarchar2(50)

BADGE

  • BADGE_ID — Primary key — NOT NULL
  • BADGE_NAME
  • BADGE_REQUIREMENT
  • BADGE_CATEGORY
  • BADGE_THUMNAIL

COURSE

  • COURSE_ID — nvarchar2(10) — Primary key — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • COURSE_CATE_ID — nvarchar2(10) — Foreign key → COURSE_CATE.COURSE_CATE_ID — NOT NULL
  • COURSE_NAME — nvarchar2(50)
  • COURSE_INTRO — nvarchar2(500)
  • COURSE_TIME — nvarchar2(10)
  • COURSE_LENGTH — nvarchar2(50)
  • COURSE_DATE — date
  • COURSE_TAG — nvarchar2(50)
  • COURSE_REGION — nvarchar2(50)

COURSE_CATE

  • COURSE_CATE_ID — nvarchar2(10) — Primary key — NOT NULL
  • COURSE_CATE_NAME — nvarchar2(50)
  • COURSE_CATE_THUMNAIL — varhcar2(500)

COURSE_COMMENT

  • COURSE_COMMENT_NO — number — Primary key — NOT NULL
  • COURSE_ID — nvarchar2(10) — Foreign key → COURSE.COURSE_ID — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → COURSE.USER_ID — NOT NULL
  • COURSE_COMMENT_CONTENT — nvarchar2(200)

COURSE_IMG

  • COURSE_ID — nvarchar2(10) — Foreign key → COURSE.COURSE_ID — NOT NULL
  • IMG_NAME — nvarchar2(30)

DIARY

  • DIARY_CODE — number — Primary key — NOT NULL
  • RECORD_ID — nvarchar2(50) — Foreign key → RECORD.RECORD_ID — NOT NULL
  • USER_ID — varchar2(30)
  • DIARY_TITLE — nvarchar2(50)
  • DIARY_MAIN_CONTENT — nvarchar2(500)
  • DIARY_DATE — date
  • DIARY_THUMNAIL — varchar2(100)

DIARY_IMG

  • DIARY_IMG_CODE — number — Primary key — NOT NULL
  • DIARY_CODE — number — Foreign key → DIARY.DIARY_CODE — NOT NULL
  • DIARY_IMG_NAME — varchar2(50)
  • DIARY_IMG_TITLE — nvarchar2(50)
  • DIARY_IMG_CONTENT — nvarchar2(500)

EVENT

  • EVENT_ID — Primary key — NOT NULL
  • EVENT_CONTENT
  • EVENT_POSTDATE
  • EVENT_TITLE

Member_

  • USER_ID — varchar2(30) — Primary key — NOT NULL
  • PWD — varchar2(2000)
  • NAME — nvarchar2(10)
  • GENDER — nvarchar2(10)
  • AGE — number
  • USERTEL — varchar2(20)
  • LASTCONNECT — date
  • USERJOINDATE — date
  • FREQUENCY — nvarchar2(100)

PACK

  • PACK_ID — varchar2(50) — Primary key — NOT NULL
  • PACK_NAME — nvarchar2(50)
  • PACK_TAG — nvarchar2(100)
  • PACK_ACT_REGION — nvarchar2(50)
  • PACK_ACT_TIME — nvarchar2(50)
  • PACK_ACT_AGE — nvarchar2(50)
  • PACK_INTRO — nvarchar2(2000)
  • PACK_THUMNAIL — varchar2(50)
  • PACK_LAT — float
  • PACK_LNG — float

PACK_BADGE_GET

  • BADGE_ID — Foreign key → BADGE.BADGE_ID — NOT NULL
  • TARGET_ID
  • GET_DATE

PACK_COMMENT

  • PACK_COMMENT_NO — numver — Primary key — NOT NULL
  • PACK_JOIN_NO — number — Foreign key → PACK_JOIN.PACK_JOIN_NO — NOT NULL
  • PACK_COMMENT_CONTENT — nvarchar2(1000)
  • PACK_COMMENT_DATE — date

PACK_COMMENT_IMG

  • PACK_COMMENT_NO — numver — Foreign key → PACK_COMMENT.PACK_COMMENT_NO — NOT NULL
  • PACK_COMMENT_IMG_NAME — varchar2(200)

PACK_COMMENT_LIKE

  • PACK_COMMENT_NO — numver — Foreign key → PACK_COMMENT.PACK_COMMENT_NO — NOT NULL
  • USER_ID (USER__ID) — varchar2(30)

PACK_COMMENT_REPLY

  • PACK_COMMENT_NO — numver — Foreign key → PACK_COMMENT.PACK_COMMENT_NO — NOT NULL
  • USER_ID — varchar2(30)
  • PACK_COMMENT_REPLY_CONTENT — varchar2(1000)
  • PACK_COMMENT_REPLY_DATE — date

PACK_CREATE

  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • PACK_ID — varchar2(50) — Foreign key → PACK.PACK_ID — NOT NULL
  • PACK_REGIDATE — date

PACK_GALLERY

  • PICTURE_NO — number — Primary key — NOT NULL
  • PACK_JOIN_NO — number — Foreign key → PACK_JOIN.PACK_JOIN_NO — NOT NULL
  • PICTURE_NAME — varchar2(100)

PACK_JOIN

  • PACK_JOIN_NO — number — Primary key — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • PACK_ID — varchar2(50) — Foreign key → PACK.PACK_ID — NOT NULL
  • PACK_JOIN_DATE — date
  • PACK_JOIN_ACCEPT — varchar2(50)
  • PACK_LASTACESS — date

PACK_MANAGER

  • PACK_ID — varchar2(50) — Foreign key → PACK.PACK_ID — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • AUTHORITY — nvarchar2(50)

PACK_NOTICE

  • PACK_NOTICE_NO — number — Primary key — NOT NULL
  • PACK_ID — varchar2(50) — Foreign key → PACK_MANAGER.PACK_ID — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → PACK_MANAGER.USER_ID — NOT NULL
  • PACK_NOTICE_TITLE — nvarchar2(100)
  • PACK_NOTICE_DATE — date
  • PACK_NOTICE_CONTENT — nvarchar2(2000)

PACK_SCHEDULE (PACK_LASTACESS)

  • PACK_SCHEDULE_NO — number — Primary key — NOT NULL
  • PACK_ID — varchar2(50) — Foreign key → PACK_MANAGER.PACK_ID — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → PACK_MANAGER.USER_ID — NOT NULL
  • PACK_SCHEDULE_START — date
  • PACK_SCHEDULE_END — date
  • PACK_SCHEDULE_TITLE — nvarchar2(100)
  • PACK_SCHEDULE_CONTENT — nvarchar2(2000)

PACK_SCHEDULE_JOIN

  • PACK_JOIN_NO — number — Foreign key → PACK_JOIN.PACK_JOIN_NO — NOT NULL
  • PACK_SCHEDULE_NO — number — Foreign key → PACK_SCHEDULE.PACK_SCHEDULE_NO — NOT NULL

PROHIBITED_WORD

  • WORD_ID — Primary key — NOT NULL
  • PROHIBITED_WORD

RECORD

  • RECORD_ID — nvarchar2(50) — Primary key — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • COURSE_ID — nvarchar2(10) — Foreign key → COURSE.COURSE_ID — NOT NULL
  • RECORD_LENGTH — float
  • RECORD_DATE — date
  • RECORD_DURATION — date

REPORT

  • REPORT_ID — varchar2(30) — Primary key — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • REPORT_TARGET_ID — varchar2(30)
  • REPORT_CATEGORY — nvarchar2(30)
  • REPORT_DATE — date
  • REPORT_REASON — nvarchar2(200)

USER_ADDR

  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • ADDRESS — nvarchar2(100)
  • USER_LAT — float
  • USER_LNG — float

USER_BADGE_GET

  • RECORD_ID — nvarchar2(50) — Foreign key → RECORD.RECORD_ID — NOT NULL
  • BADGE_ID — Foreign key → BADGE.BADGE_ID — NOT NULL
  • TARGET_ID
  • GET_DATE

USER_INTERCOUSE_CATE

  • COURSE_CATE_CODE — nvarchar2(10) — Primary key — NOT NULL
  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL

VERIFY

  • USER_ID — varchar2(30) — Foreign key → Member_.USER_ID — NOT NULL
  • VERIFY — nvarchar2(2)