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)