이기후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