서울도시건축전시관

테이블 (8)

ASA_ADMIN_ACCESS_LOG

  • LOG_ID — NUMBER — 로그
  • ADMIN_ID — VARCHAR2(50)
  • ADMIN_NAME — VARCHAR2(50)
  • LOG_REMOTE_IP — VARCHAR2(50)
  • SITE_ID — VARCHAR2(50)
  • LOG_REGDATE — DATE

ASA_BANNER

  • BN_ID — NUMBER — 아이디;
  • BN_TYPE — VARCHAR2(30)
  • BN_ORDER — NUMBER
  • BN_NAME — VARCHAR2(600)
  • BN_DESCRIPTION — VARCHAR2(2000)
  • BN_LINK — VARCHAR2(1000)
  • BN_NEW_WIN — NUMBER
  • BN_START_DATE — VARCHAR2(20)
  • BN_END_DATE — VARCHAR2(20)
  • BN_REGDATE — DATE
  • BN_USE — NUMBER
  • BN_EXT — VARCHAR2(20)
  • BN_WIDTH — NUMBER
  • BN_HEIGHT — NUMBER
  • BN_TOP — NUMBER
  • BN_LEFT — NUMBER
  • BN_THUMB — NUMBER
  • SITE_PREFIX — VARCHAR2(50)

ASA_BOARD_ARTICLE_ENG

  • BA_ID — NUMBER
  • BC_ID — VARCHAR2(100) — 게시판
  • BA_TITLE — VARCHAR2(1000)
  • BA_CONTENT_HTML — CLOB
  • BA_CONTENT_PLAIN — VARCHAR2(4000)
  • BA_NOTICE — NUMBER
  • BA_NOTICE_STARTDATE — DATE
  • BA_NOTICE_ENDDATE — DATE
  • BA_SECRET — NUMBER
  • BA_SECRET_PASSWORD — VARCHAR2(200)
  • BA_CATEGORY1 — VARCHAR2(50)
  • BA_CATEGORY2 — VARCHAR2(50)
  • BA_CATEGORY3 — VARCHAR2(50)
  • BA_STATUS — VARCHAR2(50)
  • MEM_ID — VARCHAR2(50)
  • DEP_ID — VARCHAR2(50)
  • BA_GUEST_NAME — VARCHAR2(200)
  • BA_GUEST_PASSWORD — VARCHAR2(200)
  • BA_EMAIL — VARCHAR2(200)
  • BA_IP — VARCHAR2(20)
  • BA_REGDATE — DATE
  • BA_LAST_MODIFIED — DATE
  • BA_UPDATER_ID — VARCHAR2(50)
  • BA_HIT — NUMBER
  • BA_RECOMMEND — NUMBER
  • BA_COMMENT_TOTAL — NUMBER
  • BA_THUMB — NUMBER
  • BA_NURI — VARCHAR2(50)
  • BA_USE — NUMBER
  • BA_MAIN_SELEC — NUMBER
  • BA_COMM_SELEC — NUMBER
  • BA_START_DATE — VARCHAR2(20)
  • BA_START_TIME — VARCHAR2(20)
  • BA_END_DATE — VARCHAR2(20)
  • BA_COM_SEL_CAT — VARCHAR2(50)
  • BA_THUMB_TEXT — VARCHAR2(500)
  • BA_ANSWER — VARCHAR2(4000)
  • BA_CUSTOM_FIELD_1 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_2 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_3 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_4 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_5 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_6 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_7 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_8 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_9 — VARCHAR2(500)
  • BA_CUSTOM_FIELD_10 — VARCHAR2(500)
  • BA_ONLINE_REQST_YN — VARCHAR2(20)
  • BA_WRITER — VARCHAR2(200)
  • BA_PLACE — VARCHAR2(500)
  • BA_CURATOR — VARCHAR2(200)
  • BA_INQUIRY — VARCHAR2(200)
  • BA_TARGET — VARCHAR2(200)
  • BA_PSNCPA — VARCHAR2(20)
  • BA_COST — VARCHAR2(20)
  • BA_ONLINE_TYPE — VARCHAR2(20)
  • BA_PERIOD_SDATE — VARCHAR2(20)
  • BA_PERIOD_STIME — VARCHAR2(20)
  • BA_PERIOD_EDATE — VARCHAR2(20)
  • BA_PERIOD_ETIME — VARCHAR2(20)
  • … +2

ASA_RESVE_APPLY

  • RESVE_ID — NUMBER
  • RESVE_APPLY_NAME — VARCHAR2(50)
  • RESVE_APPLY_POSITION — VARCHAR2(50)
  • RESVE_APPLY_TEL — VARCHAR2(50)
  • RESVE_APPLY_HP — VARCHAR2(50)
  • RESVE_APPLY_EMAIL — VARCHAR2(200)
  • RESVE_APPLY_ORGANIZATION — VARCHAR2(200)
  • RESVE_APPLY_ORG_DIV_CODE — VARCHAR2(50)
  • RESVE_APPLY_ZIPCODE — VARCHAR2(50)
  • RESVE_APPLY_ADDRESS — VARCHAR2(400)
  • RESVE_APPLY_ADDRESS_DETAIL — VARCHAR2(400)
  • RESVE_APPLY_TOTAL — NUMBER
  • RESVE_APPLY_DATE — VARCHAR2(20)
  • RESVE_APPLY_TIME — VARCHAR2(1000)
  • RESVE_APPLY_TIME_ADD — NUMBER
  • RESVE_APPLY_PAID_TYPE — VARCHAR2(50)
  • RESVE_APPLY_PRICE — NUMBER
  • RESVE_APPLY_DISCOUNT_RATE — NUMBER
  • RESVE_APPLY_PAYMENT_AMOUNT — NUMBER
  • RESVE_APPLY_TITLE — VARCHAR2(500)
  • RESVE_APPLY_CONTENT — VARCHAR2(4000 CHAR)
  • RESVE_APPLY_PARKING — NUMBER
  • RESVE_APPLY_FILE — NUMBER
  • RESVE_APPLY_STATUS — VARCHAR2(50)
  • RESVE_APPLY_MEMO — VARCHAR2(4000 CHAR)
  • RESVE_APPLY_REGDATE — DATE
  • RESVE_APPLY_MEMBERSHIP — NUMBER
  • RESVE_APPLY_REQUESTS — VARCHAR2(1000 CHAR)
  • RESVE_APPLY_USER_ID — VARCHAR2(50)
  • RESVE_APPLY_USAGE_TIME — NUMBER
  • RESVE_APPLY_CANCEL_DATE — VARCHAR2(20)
  • RESVE_APPLY_APPROV_DATE — VARCHAR2(20)
  • RESVE_APPLY_PAYMENT_DATE — VARCHAR2(20)
  • RESVE_APPLY_PAY_CANCEL_DATE — VARCHAR2(20)
  • RESVE_APPLY_TID — VARCHAR2(50)
  • RESVE_APPLY_ID — VARCHAR2(50)
  • RESVE_APPLY_ADULTNUM — NUMBER
  • RESVE_APPLY_CHILDNUM — NUMBER

ASA_RESVE_CLOSE_TIME

  • RESVE_DATE — VARCHAR2(20)
  • RESVE_CLOSE_TIME — VARCHAR2(50)
  • RESVE_ID — NUMBER

ASA_ROLE

  • ROLE_CODE — VARCHAR2(100)
  • ROLE_NAME — VARCHAR2(100)
  • ROLE_DESCRIPTION — VARCHAR2(1000)
  • ROLE_REGDATE — DATE — 등록일시;
  • ROLE_DEFAULT — NUMBER
  • ROLE_ADMIN — NUMBER
  • ROLE_JOIN — NUMBER

ASA_URBANARCHIVE

  • ARC_ID — NUMBER
  • URBAN_ARCHIVER — VARCHAR2(200)
  • URBAN_YEAR — VARCHAR2(20)
  • URBAN_SUPPORT — VARCHAR2(200)
  • URBAN_DONOR — VARCHAR2(200)
  • URBAN_LOCATION — VARCHAR2(200)
  • URBAN_VOLUME — VARCHAR2(200)

ASA_USER_INQUIRE_LOG

  • INQ_ID — NUMBER
  • INQ_WORKER_ID — VARCHAR2(50)
  • INQ_WORKER_NAME — VARCHAR2(50)
  • INQ_TARGET_ID — VARCHAR2(50) — 피검색자
  • INQ_TARGET_NAME — VARCHAR2(50)
  • INQ_URL — VARCHAR2(200)
  • INQ_WORK — VARCHAR2(100)
  • INQ_REMORT_IP — VARCHAR2(100)
  • INQ_REGDATE — DATE