이기후11
테이블 (50)
fscx_access
- ACCESSIDX — int — 기본 키 — NOT NULL
- ACCESSIP — varchar(64) — NOT NULL
- ACCESSMEMO — varchar(128) — NOT NULL
- REGDATE — datetime — NOT NULL
fscx_admin_log
- ADLOGIDX — int — 기본 키 — NOT NULL
- SITEIDX — int
- MEMBERIDX — int
- USERID — varchar(64) — NOT NULL
- USERNAME — varchar(64) — NOT NULL
- ACCESSREASON — varchar(128) — NOT NULL
- ACCESSURL — varchar(256)
- USERIP — varchar(256)
- USERAGENT — varchar(256)
- REGDATE — datetime — NOT NULL
fscx_admin_menu
- ADMINMENUIDX — int — 기본 키 — NOT NULL
- SITEIDX — int
- GROUPIDX — int
- ROOT — int
- REFER — int
- STEP — int
- DEPTH — int
- MENUNAME — varchar(128)
- MENUACTIVATED — tinyint
- MENUURI — varchar(512)
- MENUTARGET — varchar(2)
- MENUDESC — mediumtext
- MEMBERLEVEL — int
- REGDATE — datetime
- EDITDATE — datetime
- SUBACTIVE — int — NOT NULL
fscx_admin_site
- ADMINSITEIDX — int — 기본 키 — NOT NULL
- SITENAME — varchar(255)
- HOMEPAGE — varchar(255)
- REGDATE — datetime
- FILENAME — varchar(2000)
- FILEID — varchar(2000)
- MODIFYDATE — datetime
fscx_admin_statistics
- ASIDX — int — 기본 키 — NOT NULL
- MEMBERIDX — int
- REMOTEADDR — varchar(4000)
- USERBROWSER — varchar(4000)
- USERPLATFORM — varchar(4000)
- USERAGENT — varchar(4000)
- HTTPHOST — varchar(4000)
- ACTION — varchar(4000)
- ACCESSURL — varchar(4000)
- REGDATE — datetime
- USERTEXT — varchar(4000)
fscx_area
- AREAIDX — int — 기본 키 — NOT NULL
- AREAREMOVED — tinyint
- AREANAME — varchar(32)
- AREAORDER — int
- AREAREGDATE — datetime
fscx_area_center
- CENTERIDX — bigint — 기본 키 — NOT NULL
- AREAIDX — bigint
- CENTERNAME — varchar(1000)
- CENTERADDRESS — varchar(4000)
- CENTERTELNUM — varchar(256)
- REGDATE — datetime
- ZIPCODE — varchar(20)
- ADDRESSSTATE — varchar(256)
- ADDRESSSTREET — varchar(256)
- AREAIDX (AREAIDX2) — int — 외래 키 → fscx_area.AREAIDX — NOT NULL
fscx_area_center_img
- IMGIDX — bigint — 기본 키 — NOT NULL
- CENTERIDX — bigint
- FILEID — varchar(2000)
- FILENAME — varchar(2000)
- REGDATE — datetime
- MODIFYDATE — datetime
- AREAIDX — int — 외래 키 → fscx_area.AREAIDX — NOT NULL
fscx_area_detail
- AREADETAILIDX — bigint — 기본 키 — NOT NULL
- AREAIDX — bigint
- AREADETAILREMOVED — tinyint
- AREADETAILNAME — varchar(32)
- AREADETAILORDER — bigint
- AREADETAILREGDATE — datetime
- AREAIDX (AREAIDX2) — int — 외래 키 → fscx_area.AREAIDX — NOT NULL
fscx_area_program
- PROGRAMIDX — bigint — 기본 키 — NOT NULL
- AREAIDX — bigint
- EDUTYPE1 — bigint
- EDUTYPE2 — double
- PROGRAMNAME — varchar(4000)
- MEMBERIDX — bigint
- EDUTIME — varchar(1000)
- TARGETTYPE1 — bigint
- TARGETTYPE2 — bigint
- TARGETTYPE3 — bigint
- TARGETTYPE4 — bigint
- TARGETTYPE5 — bigint
- TARGETTYPE6 — bigint
- TARGETTYPE7 — bigint
- TARGETTYPE8 — bigint
- EDUCNT — varchar(1000)
- FILEID — varchar(2000)
- FILENAME — varchar(2000)
- REGDATE — datetime
- MODIFYDATE — datetime
- CONTENT — longtext
- AREAIDX (AREAIDX2) — int — 외래 키 → fscx_area.AREAIDX — NOT NULL
fscx_article
- ARTICLEIDX — bigint — 기본 키 — NOT NULL
- ROOT — bigint
- THREAD — bigint
- DEPTH — bigint
- BOARDIDX — bigint
- SITEIDX — bigint
- GROUPIDX — bigint
- PROPERTY — varchar(16)
- VISIBLE — bigint
- ISNOTICE — bigint
- ISSECRET — bigint
- DOCUMENTTYPE — varchar(16)
- RECENTLYCMTDATE — datetime
- REGDATE — datetime
- MODIFYDATE — datetime
- REGIPADDR — varchar(64)
- MODIFYIPADDR — varchar(64)
- REGUSERENV — varchar(512)
- MODIFYUSERENV — varchar(512)
- CMTNUM — bigint
- READCOUNT — bigint
- RECOMMENDNUM — bigint
- CATEGORY — varchar(64)
- MEMBERIDX — bigint
- AUTHORNAME — varchar(128)
- AUTHOREMAIL — varchar(256)
- AUTHORLINK — varchar(512)
- PASSWD — varchar(512)
- SUBJECT — varchar(512)
- CONTENT — longtext
- VIDEO — longtext
- TAG — varchar(512)
- TRACKBACK — varchar(256)
- REPRESENTFILEEXT — varchar(128)
- ITEM1 — varchar(512)
- ITEM2 — varchar(512)
- ITEM3 — varchar(512)
- ITEM4 — varchar(512)
- HOS_IDX — decimal(10,2)
- HOS_SCORE — bigint
- AREAIDX — bigint
- TELNUMBER — varchar(20)
- HOMEPAGELINK — varchar(512)
- ZIPCODE — varchar(10)
- ADDRESSSTATE — varchar(256)
- ADDRESSSTREET — varchar(256)
- EDUCATEIDX — bigint
- WEBLINK — varchar(4000)
- MOBILELINK — varchar(4000)
- AREADETAILIDX — double
- MAINVIEW — varchar(10)
- MAINORDER — varchar(10)
fscx_banner
- BANNERIDX — int — 기본 키 — NOT NULL
- SITEIDX — int
- GROUPIDX — int
- BANNERSEQ — int
- BANNERTITLE — varchar(128)
- BANNERURL — varchar(512)
- BANNERIMAGE — varchar(128)
- BANNERIMAGEID — varchar(256)
- BANNERWIDTH — int
- BANNERHEIGHT — int
- BANNERDISPLAY — tinyint(1)
- BANNERNEWWINDOW — tinyint(1)
- BANNERDESC — mediumtext
- REGDATE — datetime
- EDITDATE — datetime
fscx_basic_center
- CENTERIDX — bigint — 기본 키 — NOT NULL
- AREAIDX — bigint
- AREADETAILIDX — bigint
- CENTERNAME — varchar(1000)
- CENTERTEL — varchar(1000)
- CENTERADDRESS — varchar(2000)
- PROGRAMNAME — varchar(1000)
- CONTENT — longtext
- SITECHECK — bigint
- SITEADDRESS — varchar(1000)
- FILEID — varchar(256)
- FILENAME — varchar(256)
- REGDATE — datetime
- MODIFYDATE — datetime
fscx_board
- BOARDIDX — int — 기본 키 — NOT NULL
- SITEIDX — int
- GROUPIDX — int
- MENUIDX — int
- CREATEDATE — datetime
- ADJUSTDATE — datetime
- ACCESSDATE — datetime
- TODAYVISITCOUNT — int
- TOTALVISITCOUNT — int
- TOTALARTICLECOUNT — int
- BOARDID — varchar(128)
- BOARDNAME — varchar(128)
- ADMINMEMBERIDXS — mediumtext
- ADMINPASSWD — varchar(512)
- BOARDSKIN — varchar(128)
- BOARDWIDTH — int
- BOARDALIGN — char(1)
- SUBJECTRESTRICTCHARNUM — int
- AUTHORRESTRICTCHARNUM — int
- CONTENTRESTRICTCHARNUM — int
- PAGEITEMNUM — int
- PAGESHORTCUTNUM — int
- NOTIFYITEMNUM — int
- HEADCONTENT — longtext
- TAILCONTENT — longtext
- WRITEFORMDEFCONTENT — longtext
- USESHOWLISTINCONTENT — tinyint(1)
- USECOMMENT — tinyint(1)
- USEREPLY — tinyint(1)
- USETAGCLOUD — tinyint(1)
- USETRACKBACK — tinyint(1)
- USERSSFEED — tinyint(1)
- USEAUTOLINK — tinyint(1)
- USECONTENTPREVIEW — tinyint(1)
- USESECRET — tinyint(1)
- USERESTRICTSPAM — tinyint(1)
- USERESTRICTOUTLINK — tinyint(1)
- USEHIDEUNNECESSARYBUTTON — tinyint(1)
- USESHOWAUTHORIP — tinyint(1)
- USESHOWAUTHORENV — tinyint(1)
- DEFAULTEDITMODE — char(1)
- EDITORTYPE — char(1)
- HTMLCONTENTMODE — char(1)
- ALLOWHTMLS — mediumtext
- USEATTACHFILE — tinyint(1)
- ALLOWATTACHFILESIZE — int
- ALLOWATTACHFILENUM — int
- ALLOWATTACHFILEEXTS — mediumtext
- ATTACHEDFILEPATH — varchar(256)
- USEAUTOEXECATTACHEDFILE — tinyint(1)
- ALLOWAUTOEXECATTACHEDFILEEXTS — mediumtext
- DISPLAYNEWICON — char(1)
- TERMNEWICON — int
- USERESIZEIMAGE — tinyint(1)
- RESIZEIMAGEWIDTHSIZE — int
- USECATEGORY — tinyint(1)
- CATEGORYLISTS — longtext
- USEWORDFILTER — tinyint(1)
- BADWORDS — longtext
- USECAPTCHA — tinyint
- … +12
fscx_calendar
- CALENDARIDX — int — 기본 키 — NOT NULL
- CALENDARCATEGORY — varchar(32) — NOT NULL
- CALENDARSUBJECT — varchar(64) — NOT NULL
- CALENDARCONTENT — text — NOT NULL
- CALENDARSTARTDATE — date — NOT NULL
- CALENDARENDDATE — date — NOT NULL
- CALENDARREGDATE — datetime — NOT NULL
- CALENDARITEM1 — varchar(256) — NOT NULL
- CALENDARITEM2 — varchar(256) — NOT NULL
- CALENDARITEM3 — varchar(256) — NOT NULL
- CALENDARITEM4 — varchar(256) — NOT NULL
fscx_calendar_category
- CATEGORYIDX — int — 기본 키 — NOT NULL
- CATEGORYNAME — varchar(64) — NOT NULL
- CATEGORYENNAME — varchar(64) — NOT NULL
- CALENDARIDX — int — 외래 키 → fscx_calendar.CALENDARIDX — NOT NULL
fscx_center_edu
- CEDUIDX — bigint — 기본 키 — NOT NULL
- AREAIDX — bigint
- EDUTYPE — bigint
- PROGRAMNAME — varchar(4000)
- PROGRAMINTRO — varchar(4000)
- TARGETTYPE1 — bigint
- TARGETTYPE2 — bigint
- TARGETTYPE3 — bigint
- TARGETTYPE4 — bigint
- TARGETTYPE5 — bigint
- TARGETTYPE6 — bigint
- TARGETTYPE7 — bigint
- TARGETTYPE8 — bigint
- CEDUCOUNT — bigint
- CEDUCNT — bigint
- CEDUTIME — varchar(1000)
- FILEID — varchar(256)
- FILENAME — varchar(256)
- REGDATE — datetime
- MODIFYDATE — datetime
- MEMBERIDX — bigint
- CONTENT — longtext
- CEDUSTARTDATE — datetime
- CEDUENDDATE — datetime
- PROGRAMTYPE — bigint
- SITEADDRESS — varchar(4000)
- CEDUSTATUS — bigint
- TARGETETCNAME — varchar(1000)
- ENDSTATUS — bigint — 1: 마감
fscx_center_edu_apply
- APPLYIDX — bigint — 기본 키 — NOT NULL
- MEMBERIDX — bigint
- CEDUIDX — bigint
- APPLYNAME — varchar(512)
- APPLYCOUNT — bigint
- APPLYTEL — varchar(128)
- APPLYEMAIL — varchar(512)
- APPLYDATE1 — datetime
- APPLYDATE2 — datetime
- REGDATE — datetime
- MODIFYDATE — datetime
- APPLYSTATUS — bigint
- APPLYIPADDR — varchar(128)
- APPLYUSERAGENT — varchar(512)
- CONFIRMDATE — datetime
- CEDUIDX (CEDUIDX2) — bigint — 외래 키 → fscx_center_edu.CEDUIDX — NOT NULL
fscx_certificate
- CERTIFICATEIDX — bigint — 기본 키 — NOT NULL
- ONLINEEDUIDX — bigint
- ONLINEEDUAPPLYIDX — bigint
- MEMBERIDX — bigint
- REGDATE — varchar(32)
- CERTIORDER — bigint
- CERTISTATUS — tinyint
fscx_code
- CODEIDX — int — 기본 키 — NOT NULL
- CODEID — varchar(128)
- CODETYPE — varchar(128)
- CODENAME — varchar(128)
- CODEVALUE — varchar(128)
- CODEDESC — varchar(128)
- CODESEQ — int
- REGDATE — datetime
- EDITDATE — datetime
fscx_comment
- COMMENTIDX — int — 기본 키 — NOT NULL
- COMMENTROOT — int
- COMMENTTHREAD — int
- COMMENTDEPTH — int
- ARTICLEIDX — int
- BOARDIDX — int
- SITEIDX — int
- GROUPIDX — int
- MEMBERIDX — int
- PROPERTY — varchar(16)
- VISIBLE — tinyint
- ISNOTICE — tinyint(1)
- ISSECRET — tinyint(1)
- DOCUMENTTYPE — varchar(16)
- REGDATE — datetime
- MODIFYDATE — datetime
- REGIPADDR — varchar(64)
- MODIFYIPADDR — varchar(64)
- REGUSERENV — varchar(512)
- MODIFYUSERENV — varchar(512)
- AUTHORNAME — varchar(128)
- AUTHOREMAIL — varchar(256)
- PASSWD — varchar(512)
- CONTENT — longtext
fscx_content
- CONTENTIDX — int — 기본 키 — NOT NULL
- MENUIDX — int
- SITEIDX — int
- GROUPIDX — int
- CONTENTFILENAME — varchar(128)
- VIEWLEVEL — int
- VIEWCOUNT — int
- REGDATE — datetime
- EDITDATE — datetime
- CONTENTTITLE — varchar(512)
- CONTENTBODY — longtext
- CONTENTCSS — longtext
fscx_depart
- DEPARTIDX — bigint — 기본 키 — NOT NULL
- DEPARTREMOVED — tinyint
- DEPARTNAME — varchar(32)
- DEPARTREGDATE — datetime
- DEPARTMODIFYDATE — datetime
fscx_dust_air
- AIRIDX — bigint — 기본 키 — NOT NULL
- AIRNAME — varchar(500)
- AIRYEAR — varchar(500)
- AIRADDR — varchar(2000)
- AIROPER — varchar(1000)
- AIRLOCATIONX — varchar(500)
- AIRLOCATIONY — varchar(500)
- AIRSIDO — varchar(500)
- AIRGU — varchar(500)
- AIRPHOTO — varchar(1000)
fscx_dust_air_value
- AVIDX — bigint — 기본 키 — NOT NULL
- AIRIDX — bigint
- AVSO2 — varchar(500)
- AVCO — varchar(500)
- AVO3 — varchar(500)
- AVNO2 — varchar(500)
- AVPM25 — varchar(500)
- AVPM10 — varchar(500)
- AVDATETIME — varchar(500)
- AVREGDATE — datetime
- AIRIDX (AIRIDX2) — bigint — 외래 키 → fscx_dust_air.AIRIDX — NOT NULL
fscx_dust_area_point
- POIIDX — bigint — 기본 키 — NOT NULL
- POISIDO — varchar(500)
- POIGU — varchar(500)
- POIDONG — varchar(500)
- AREANAME — varchar(500)
- POIX — varchar(500)
- POIY — varchar(500)
- POIWX — double
- POIWY — double
- LIVINGIDX — bigint
- AREAIDX — int — 외래 키 → fscx_area.AREAIDX — NOT NULL
fscx_dust_area_weather
- WEIDX — bigint — 기본 키 — NOT NULL
- POIIDX — bigint
- WESIDO — varchar(500)
- WEGU — varchar(500)
- WEDONG — varchar(500)
- WEDATE — varchar(500)
- WETEMP — double
- WERAIN — double
- WESKY — bigint
- WEEWIND — double
- WENWIND — double
- WEHUMI — double
- WERAINTYPE — bigint
- WETHUNDER — bigint
- WEWINDLOCATION — double
- WEWINDSPEED — double
- WEREGDATE — datetime
fscx_education
- EDUCATIONIDX — bigint — 기본 키 — NOT NULL
- PROGRAMIDX — bigint
- MEMBERIDX — bigint
- PROGRAMTYPE — bigint
- PROGRAMNAME — varchar(256)
- PROGRAMTIME — varchar(20)
- PROGRAMTARGET — varchar(256)
- APPLYSTATUS — varchar(256)
- APPLYNAME — varchar(256)
- APPLYCOUNT — varchar(20)
- APPLYPHONE — varchar(20)
- APPLYEMAIL — varchar(256)
- REGDATE — datetime
- APPLYDATE1 — datetime
- APPLYDATE2 — datetime
- APPLYCONTENT — longtext
fscx_file_dl_archive
- FILEDLIDX — bigint — 기본 키 — NOT NULL
- FILEIDX — bigint
- ARTICLEIDX — bigint
- BOARDIDX — bigint
- SITEIDX — bigint
- GROUPIDX — bigint
- MEMBERIDX — bigint
- MEMBERLEVEL — bigint
- MEMBERNAME — varchar(128)
- BOARDNAME — varchar(128)
- FILENAME — varchar(256)
- IPADDR — varchar(64)
- USERENV — varchar(512)
- DOWNLOADDATE — datetime
- FILEIDX (FILEIDX2) — bigint — 외래 키 — NOT NULL
fscx_group
- GROUPIDX — int — 기본 키 — NOT NULL
- GROUPNAME — varchar(64)
- GROUPOPENED — tinyint(1)
- GROUPACCESSLEVEL — int
- GROUPDESC — mediumtext
- REGDATE — datetime
- EDITDATE — datetime
fscx_lecture
- LECTUREIDX — bigint — 기본 키 — NOT NULL
- MEMBERIDX — bigint
- TEACHERIDX — bigint
- SUBJECT — varchar(4000)
- CONTENT — longtext
- REGDATE — datetime
- MODIFYDATE — datetime
- STATUS — bigint
- EDUDATE — datetime
fscx_lecture_quiz
- QUIZIDX — bigint — 기본 키 — NOT NULL
- QUIZTYPE — bigint
- QUIZTITLE — varchar(4000)
- REGDATE — datetime
- MODIFYDATE — datetime
- ONLINEEDUIDX — bigint
- QUIZSTEP — double
- LECTUREIDX — bigint — 외래 키 → fscx_lecture.LECTUREIDX — NOT NULL
fscx_lecture_quiz_comment
- COMIDX — bigint — 기본 키 — NOT NULL
- COMREMOVED — tinyint
- ONLINEEDUIDX — bigint
- QUIZIDX — bigint
- COMROOT — bigint
- COMSTEP — bigint
- COMDEPTH — bigint
- MEMBERIDX — bigint
- COMMSG — longtext
- REGDATE — datetime
- MODIFYDATE — datetime
- COMREGIP — varchar(2000)
- COMTYPE — tinyint
- COMTITLE — varchar(4000)
- LECTUREIDX — bigint — 외래 키 → fscx_lecture.LECTUREIDX — NOT NULL
fscx_lecture_quiz_detail
- QDIDX — int — 기본 키 — NOT NULL
- QUIZIDX — double
- QDTEXT — longtext
- QDCHECK — tinyint
- QDSTEP — bigint
- LECTUREIDX — bigint — 외래 키 → fscx_lecture.LECTUREIDX — NOT NULL
fscx_lecture_quiz_result
- QRIDX — bigint — 기본 키 — NOT NULL
- MEMBERIDX — bigint
- ONLINEEDUIDX — bigint
- QUIZIDX — bigint
- QDIDX — bigint
- QRCHECK — longtext
- REGDATE — varchar(32)
- LECTUREIDX — bigint — 외래 키 → fscx_lecture.LECTUREIDX — NOT NULL
fscx_login_archive
- LOGINIDX — bigint — 기본 키 — NOT NULL
- MEMBERIDX — bigint
- SITEIDX — bigint
- GROUPIDX — bigint
- LOGINID — varchar(128)
- LOGINNAME — varchar(128)
- LOGINIPADDR — varchar(64)
- LOGINENV — varchar(512)
- LOGINDATE — datetime
- FAILSTRING — varchar(256)
- CERTIFICATED — bigint
fscx_mail_not
- MAILIDX — int — 기본 키 — NOT NULL
- MAILUSEDURL — varchar(256) — NOT NULL
- MAILREASON — text — NOT NULL
- MAILREGDATE — datetime — NOT NULL
- MAILREGIP — varchar(64) — NOT NULL
- MAILIDX (MAILIDX2) — bigint — 외래 키 — NOT NULL
fscx_member
- MEMBERIDX — bigint — 기본 키 — NOT NULL
- SITEIDX — bigint
- GROUPIDX — bigint
- MEMBERLEVEL — bigint
- MEMBERAUTH — bigint
- MEMBERREMOVED — bigint
- MEMBERCLASS — varchar(32)
- MEMBERGRADE — varchar(16)
- MEMBERREGDATE — datetime
- MEMBERMODIFYDATE — datetime
- MEMBERREMOVEDATE — datetime
- MEMBERREGIPADDR — varchar(64)
- MEMBERREMOVEADDR — varchar(64)
- MEMBERMODIFYIPADDR — varchar(64)
- MEMBERREGUSERENV — varchar(512)
- MEMBERMODIFYUSERENV — varchar(512)
- MEMBERLOGINDATE — datetime
- MEMBERLOGINIPADDR — varchar(64)
- MEMBERLOGINUSERENV — varchar(512)
- MEMBERLOGINCOUNT — bigint
- MEMBERID — varchar(128)
- MEMBERPASSWD — varchar(512)
- MEMBERNAME — varchar(128)
- MEMBERNICKNAME — varchar(128)
- MEMBERIDSN — varchar(128)
- MEMBERIPINCODE — varchar(128)
- MEMBERSEX — varchar(1)
- MEMBERBIRTHDAY — varchar(16)
- MEMBERBIRTHDAYISLUNAR — bigint
- MEMBERQUESTION — bigint
- MEMBERANSWER — varchar(128)
- MEMBEREMAIL — varchar(256)
- MEMBERALLOWRECEIVEEMAIL — bigint
- MEMBERSITE — varchar(256)
- MEMBERZIPCODE — varchar(8)
- MEMBERADDRESSSTATE — varchar(256)
- MEMBERADDRESSSTREET — varchar(256)
- MEMBERTELNUM — varchar(16)
- MEMBERCELLPHONENUM — varchar(16)
- MEMBEROCCUPATION — varchar(32)
- MEMBERCOMPANYNAME — varchar(64)
- MEMBERCOMPANYTELNUM — varchar(16)
- MEMBERCOMPANYFAXNUM — varchar(16)
- MEMBERCOMPANYZIPCODE — varchar(8)
- MEMBERCOMPANYADDRSTATE — varchar(256)
- MEMBERCOMPANYADDRSTREET — varchar(256)
- MEMBERPICTUREFILE — varchar(128)
- MEMBERPICTUREFILEID — varchar(128)
- MEMBERSYMBOLICONFILE — varchar(128)
- MEMBERSYMBOLICONFILEID — varchar(128)
- MEMBERNAMEICONFILE — varchar(128)
- MEMBERNAMEICONFILEID — varchar(128)
- MEMBERCODE — varchar(256)
- MEMBERREMARK — longtext
- MEMBERMAILCHECK — bigint
- MEMBERPHONECHECK — bigint
- MEMBERTYPE — bigint
- AREAIDX — bigint
- AREADETAILIDX — bigint
- DEPARTIDX — bigint
- … +18
fscx_member_history
- HIS_IDX — bigint — 기본 키 — NOT NULL
- MEMBERIDX — bigint
- HIS_TYPE — varchar(20) — LAB / RAD
- SEQNUM — bigint
- HIS_FILE_REAL — varchar(128) — ?????
- HIS_FILE_NAME — varchar(128) — ??????
- HIS_REGDATE — datetime
- MEMBERIDX (MEMBERIDX2) — bigint — 외래 키 → fscx_member.MEMBERIDX — NOT NULL
fscx_member_level
- MEMBERLEVELIDX — bigint — 기본 키 — NOT NULL
- SITEIDX — bigint
- GROUPIDX — bigint
- LEVELNUM — bigint
- LEVELNAME — varchar(64)
- REGDATE — datetime
- EDITDATE — datetime
- MEMBERIDX — bigint — 외래 키 → fscx_member.MEMBERIDX — NOT NULL
fscx_menu_statistics
- MENUSTATISTICSIDX — bigint — 기본 키 — NOT NULL
- SITEIDX — bigint
- GROUPIDX — bigint
- REMOTEADDR — varchar(64)
- USERBROWSER — varchar(128)
- USERPLATFORM — varchar(128)
- USERAGENT — varchar(512)
- HTTPHOST — varchar(512)
- HTTPREFERER — varchar(128)
- USERID — varchar(128)
- MENUIDX — bigint
- ACCESSDATE — datetime
- SITEIDX (SITEIDX2) — bigint — 외래 키 — NOT NULL
fscx_mobile
- MOBILEIDX — bigint — 기본 키 — NOT NULL
- MOBILESITETYPE — bigint
- MOBILESITECONTENT — varchar(128)
- MOBILESINGLE — bigint
- MOBILEMENUTYPE — bigint
fscx_mobile_menu
- MOBILEMENUIDX — bigint — 기본 키 — NOT NULL
- SITEIDX — bigint
- GROUPIDX — bigint
- ROOT — bigint
- REFER — bigint
- STEP — bigint
- DEPTH — bigint
- MENUPROPERTY — bigint
- MENUNAME — varchar(128)
- MENUACTIVATED — bigint
- MENUTYPE — bigint
- MENUURI — varchar(512)
- MENUTARGETIDX — bigint
- MENUTARGET — varchar(2)
- MENUDESC — longtext
- MEMBERLEVEL — bigint
- REGDATE — datetime
- EDITDATE — datetime
- VIEWLEVEL — bigint
- MYPAGECHECK — bigint
- MOBILEIDX — bigint — 외래 키 → fscx_mobile.MOBILEIDX — NOT NULL
fscx_note
- NOTEIDX — int — 기본 키 — NOT NULL
- SITEIDX — int
- GROUPIDX — int
- NOTEPROPERTY — char(1)
- NOTESTATUS — char(1)
- SENDERMEMBERIDX — int
- RECEIVERMEMBERIDX — int
- SENTDATE — datetime
- RECEIVEDDATE — datetime
- CONFIRMDATE — datetime
- COMMENT — mediumtext
fscx_notice_list
- NOTICEIDX — bigint — 기본 키 — NOT NULL
- MEMBERIDX — bigint
- RECEIVEIDX — bigint
- SUBJECT — varchar(2000)
- CONTENT — varchar(4000)
- REMOVED — bigint
- REGDATE — datetime
- MODIFYDATE — datetime
- TYPE — varchar(20)
- TYPEIDX — bigint
- AREAIDX — bigint
- NOTEIDX — int — 외래 키 → fscx_note.NOTEIDX — NOT NULL
fscx_online_education
- ONLINEEDUIDX — bigint — 기본 키 — NOT NULL
- SUBJECT — varchar(256)
- PERIOD — varchar(256)
- PRICE — varchar(256)
- METHOD — varchar(256)
- THUMBNAILID — varchar(256)
- THUMBNAILNAME — varchar(256)
- REGDATE — datetime
- TEACHERIDX — bigint
- MEMBERIDX — bigint
- CONTENT — longtext
- MODIFYDATE — datetime
- CATEGORY — varchar(256)
- CERTIFICATE — bigint — 0: 수료증없음 1: 수료증 있음
- WEBLINK — varchar(4000)
- MOBILELINK — varchar(4000)
- CHECKTIME — bigint — 강의시간
- AREAIDX — bigint — 지역IDX
- VISIBLE — bigint — 승인여부
- STARTDATE — datetime
- ENDDATE — datetime
- OEQUIZTYPE — tinyint — 퀴즈 타입
- APPLYSTARTDATE — datetime — 수강신청기간
- APPLYENDDATE — datetime — 수강신청기간
- LECTARGET — varchar(256) — 수강대상
- TARGETMEMBER — double — 일반회원
- TARGETTEACHER — double — 강사회원
- TARGETLOCALADMIN — double — 광역관리자
- TARGETADMIN — double — 전체관리자
- AUTHCHECK — double — 승인여부
- TARGETAREA — double — 광역
- EDUTYPE — double — 0:퀴즈/설문 사용, 1:퀴즈/설문 미사용
- REMOVED — double — 1:삭제
fscx_online_education_apply
- ONLINEEDUAPPLYIDX — bigint — 기본 키 — NOT NULL
- ONLINEEDUIDX — bigint
- TEACHERIDX — bigint
- MEMBERIDX — bigint
- STATUS — bigint
- REGDATE — datetime
- STARTDATE — datetime
- ENDDATE — datetime
- APPROVALDATE — datetime
- CERTIFICATEREGDATE — varchar(32)
- CERTIFICATEIDX — bigint
- VIDEOLENGTH — bigint
- LECTURELENGTH — bigint
- LECTURESTATUS — bigint
- QUIZSTATUS — tinyint
- APPLYSTATUS — tinyint
- COMPLETEDATE — varchar(32)
- REMOVED — double
- ONLINEEDUIDX (ONLINEEDUIDX2) — bigint — 외래 키 → fscx_online_education.ONLINEEDUIDX — NOT NULL
fscx_online_education_lecture
- LECIDX — bigint — 기본 키 — NOT NULL
- ONLINEEDUIDX — bigint
- WEBLINK — varchar(4000)
- MOBILELINK — varchar(4000)
- LECTIME — bigint
- REGDATE — varchar(20)
- MODIFYDATE — varchar(20)
- LECSUBJECT — varchar(256)
- REMOVED — double
- ONLINEEDUIDX (ONLINEEDUIDX2) — bigint — 외래 키 → fscx_online_education.ONLINEEDUIDX — NOT NULL
fscx_online_education_target
- TARGETIDX — double — 기본 키 — NOT NULL
- ONLINEEDUIDX — double
- MEMBERIDX — double
- REGDATE — datetime
- ONLINEEDUIDX (ONLINEEDUIDX2) — bigint — 외래 키 → fscx_online_education.ONLINEEDUIDX — NOT NULL
fscx_online_education_time
- TIDX — bigint — 기본 키 — NOT NULL
- LECIDX — bigint
- MEMBERIDX — bigint
- CHECKTIME — varchar(20) — 진도율\r\n
- TCHECK — bigint — 완료시 1\r\n
- APPIDX — double
- COMPLETEDATE — varchar(32) — 완료날짜
- ONLINEEDUIDX — bigint — 외래 키 → fscx_online_education.ONLINEEDUIDX — NOT NULL