서울도시건축전시관
테이블 (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