SIDIZ ERD
Tables (54)
T_ADMIN
- ADMIN_ID — NVARCHAR(20) — Primary key — NOT NULL
- ADMIN_NAME — NVARCHAR(20) — NOT NULL
- PASSWORD — NVARCHAR(150) — NOT NULL
- ADMIN_EP_ID_LIST — NVARCHAR(300)
- REMARK — NVARCHAR(300) — NOT NULL
- USE_YN — NCHAR(1) — NOT NULL
- LAST_LOGIN_IP — NVARCHAR(20)
- LAST_LOGIN_DT — DATETIME
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
- LOGIN_CNT — INT
- DEL_DT — DATETIME
- LAST_SESSION_ID — NVARCHAR(40)
- ADMIN_ROLE — NVARCHAR(10) — NOT NULL
T_ADMIN_EVENT
- EVENT_NO — INT — Primary key — NOT NULL
- USER_ID — NVARCHAR(20) — Foreign key → T_ADMIN.ADMIN_ID — NOT NULL
- SYS_DT — DATETIME — NOT NULL
- EVENT_IP — NCHAR(15) — NOT NULL
- EVENT_URL — NVARCHAR(200) — NOT NULL
T_ADMIN_LOG
- LOG_NO — INT — Primary key — NOT NULL
- USER_ID — NVARCHAR(20) — NOT NULL
- SYS_DT — DATETIME — NOT NULL
- LOG_TYPE — NCHAR(2) — NOT NULL
- REASON — NVARCHAR(100) — NOT NULL
- ADMIN_ID — NVARCHAR(20) — Foreign key → T_ADMIN.ADMIN_ID — NOT NULL
T_ADMIN_LOGGING
- ID — INT — Primary key — NOT NULL
- PAGE — NVARCHAR(300) — NOT NULL
- ADMIN_ID — NVARCHAR(100) — Foreign key → T_ADMIN.ADMIN_ID — NOT NULL
- IP — NVARCHAR(200) — NOT NULL
- AGENT — NVARCHAR(300) — NOT NULL
- TYPE — NVARCHAR(10) — NOT NULL
- CONTENT — TEXT — NOT NULL
- DATE — DATETIME — NOT NULL
T_CART
- CART_ID — NVARCHAR(32) — Primary key — NOT NULL
- COLOR_CD — NVARCHAR(10) — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(20) — Primary key — NOT NULL
- USER_CD — NVARCHAR(10) — Primary key — NOT NULL
- QTY — INT — NOT NULL
- SYS_DT — DATETIME
T_CATEGORY
- CATE_NO — INT — Primary key — NOT NULL
- CATE_NAME — NVARCHAR(100) — NOT NULL
- CATE_URL — NVARCHAR(50) — NOT NULL
- PARENT — INT — NOT NULL
- USE_YN — NCHAR(1) — NOT NULL
- SEQ — INT — NOT NULL
- CATE_IMG — VARCHAR(50)
- TITLE_IMG1 — VARCHAR(50)
- TITLE_IMG2 — VARCHAR(50)
- FEATURE_IMG — VARCHAR(50)
- FEATURE_URL — VARCHAR(50)
T_CODE
- CODE — NVARCHAR(6) — Primary key — NOT NULL
- NAME — NVARCHAR(100) — NOT NULL
- PREFIX — NCHAR(3) — NOT NULL
- SEQ — INT — NOT NULL
- USE_YN — NCHAR(1) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
- PARENT_CODE — NVARCHAR(6)
- METADATA — TEXT
T_COMPARE
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- SESSION_ID — NVARCHAR(32) — Primary key — NOT NULL
- USER_CD — NVARCHAR(10) — Primary key — NOT NULL
- SYS_DT — DATETIME
T_CONTENTS
- CONTENTS_NO — NCHAR(10) — Primary key — NOT NULL
- CONTENTS_NAME — NVARCHAR(200) — NOT NULL
- CATE_CD — NCHAR(6) — NOT NULL
- SEQ — INT — NOT NULL
- REG_ID — NVARCHAR(30) — NOT NULL
- REG_DT — DATETIME
T_CONTENTS_DATA
- CONTENTS_NO — NCHAR(10) — Primary key — NOT NULL
- DATA_NO — INT — Primary key — NOT NULL
- TYPE — NVARCHAR(5) — NOT NULL
- TITLE — NVARCHAR(300) — NOT NULL
- CONTENTS — NTEXT — NOT NULL
- IMAGE_NO — NVARCHAR(30) — NOT NULL
- LINK_URL — NVARCHAR(300) — NOT NULL
- LINK_TARGET — NVARCHAR(10)
- SEQ — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
- MARGIN — NVARCHAR(100) — NOT NULL
- SUBTITLE — NVARCHAR(1000) — NOT NULL
- BADGE_TITLE — NVARCHAR(200)
- BADGE_THUMBNAIL — NVARCHAR(1000)
- BADGE_LINK — NVARCHAR(1000)
T_CONTENTS_MAP
- CONTENTS_NO — NCHAR(10) — Primary key — NOT NULL
- DATA_NO — INT — Primary key — NOT NULL
- MAP_NO — INT — Primary key — NOT NULL
- SHAPE — NVARCHAR(20) — NOT NULL
- COORDS — NVARCHAR(100) — NOT NULL
- LINK_URL — NVARCHAR(300) — NOT NULL
- LINK_TARGET — NVARCHAR(50) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_DB_ZIPCODE
- ID — INT — Primary key — NOT NULL
- ZIPCODE — NVARCHAR(10) — NOT NULL
- ADDR01 — NVARCHAR(50)
- ADDR02 — NVARCHAR(254)
- ADDR03 — NVARCHAR(254)
- ADDRFULL — NVARCHAR(254)
- LAWCODE — NVARCHAR(20)
- LAWSTATUS — CHAR(1)
T_EVENT
- EVENT_NO — INT — Primary key — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS_NO — NCHAR(10) — NOT NULL
- EVENT_IMG — NVARCHAR(50) — NOT NULL
- TITLE_IMG1 — NVARCHAR(50)
- TITLE_IMG2 — NVARCHAR(50)
- FR_DT — DATETIME — NOT NULL
- TO_DT — DATETIME — NOT NULL
- END_YN — NCHAR(1) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- HITS — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_FAQ
- FAQ_NO — INT — Primary key — NOT NULL
- FAQ_TYPE — NCHAR(6) — NOT NULL
- TITLE — NVARCHAR(300) — NOT NULL
- CONTENTS — NTEXT — NOT NULL
- SEQ — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_FILE
- FILE_NO — NVARCHAR(30) — Primary key — NOT NULL
- FILE_NAME — NVARCHAR(300) — NOT NULL
- REAL_NAME — NVARCHAR(300) — NOT NULL
- FILE_EXT — NVARCHAR(10) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
- PATH — NVARCHAR(50) — NOT NULL
T_FILE_EDITOR
- FILE_EDITOR_NO — INT — Primary key — NOT NULL
- FILE_PHYSICAL_NM — NVARCHAR(300) — NOT NULL
- FILE_LOGICAL_NM — NVARCHAR(300) — NOT NULL
- FILE_EXT — NVARCHAR(10) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
- FILE_PATH — NVARCHAR(300) — NOT NULL
- CONTENT_TYPE — NVARCHAR(50) — NOT NULL
- CONTENT_NO — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME — NOT NULL
T_IR
- IR_NO — INT — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS_IMG — NVARCHAR(50) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- HITS — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
- DEL_YN — NCHAR(1) — NOT NULL
T_KEY_NO
- PREFIX — NVARCHAR(3) — Primary key — NOT NULL
- YYMM — NVARCHAR(6) — Primary key — NOT NULL
- LAST_NO — INT — NOT NULL
T_NEWS
- NEWS_NO — INT — Primary key — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS_NO — NCHAR(10) — NOT NULL
- NEWS_IMG — NVARCHAR(50) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- HITS — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_ORDER
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- ORDER_DT — DATETIME — NOT NULL
- BUYER_CD — NVARCHAR(10) — NOT NULL
- BUYER_NAME — NVARCHAR(20) — NOT NULL
- BUYER_EMAIL — NVARCHAR(50) — NOT NULL
- BUYER_PHONE — NVARCHAR(20) — NOT NULL
- NAME — NVARCHAR(20) — NOT NULL
- ZIPCODE — NVARCHAR(10) — NOT NULL
- ADDRESS1 — NVARCHAR(150) — NOT NULL
- ADDRESS2 — NVARCHAR(150) — NOT NULL
- PHONE1 — NVARCHAR(20) — NOT NULL
- PHONE2 — NVARCHAR(20) — NOT NULL
- REMARK — NVARCHAR(300) — NOT NULL
- PAY_TYPE — NCHAR(6) — NOT NULL
- STATUS — NCHAR(6) — NOT NULL
- SYS_ID — NVARCHAR(20) — NOT NULL
- SYS_DT — DATETIME
- AUTO_DELETE_INFO_DT — DATETIME
T_ORDER_CANCEL
- CANCEL_NO — INT — Primary key — NOT NULL
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — NOT NULL
- COLOR_CD — NVARCHAR(20) — NOT NULL
- CANCEL_QTY — INT — NOT NULL
- CANCEL_RMK — NVARCHAR(200) — NOT NULL
- SYS_ID — NVARCHAR(20) — NOT NULL
- SYS_DT — DATETIME
T_ORDER_CANCEL_REQ
- ORDER_CANCEL_REQ_NO — INT — Primary key — NOT NULL
- ORDER_NO — NCHAR(15) — NOT NULL
- ORDER_CANCEL_REASON — CHAR(5) — NOT NULL
- REFUND_BANK_CODE — CHAR(2)
- REFUND_ACCOUNT_NO — VARCHAR(100)
- REFUND_ACCOUNT_OWNER — VARCHAR(100)
- REFUND_ACCOUNT_OWNER_BIRTHDAY — VARCHAR(100)
- IS_CANCELED — BIT — NOT NULL
- REG_DT — DATETIME — NOT NULL
T_ORDER_INACTIVE
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- ORDER_DT — DATETIME — NOT NULL
- BUYER_CD — NVARCHAR(10) — NOT NULL
- BUYER_NAME — NVARCHAR(20) — NOT NULL
- BUYER_EMAIL — NVARCHAR(50) — NOT NULL
- BUYER_PHONE — NVARCHAR(20) — NOT NULL
- NAME — NVARCHAR(20) — NOT NULL
- ZIPCODE — NVARCHAR(10) — NOT NULL
- ADDRESS1 — NVARCHAR(150) — NOT NULL
- ADDRESS2 — NVARCHAR(150) — NOT NULL
- PHONE1 — NVARCHAR(20) — NOT NULL
- PHONE2 — NVARCHAR(20) — NOT NULL
- REMARK — NVARCHAR(300) — NOT NULL
- PAY_TYPE — NCHAR(6) — NOT NULL
- STATUS — NCHAR(6) — NOT NULL
- SYS_ID — NVARCHAR(20) — NOT NULL
- SYS_DT — DATETIME
- AUTO_DELETE_INFO_DT — DATETIME
T_ORDER_OLD
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- ORDER_DT — DATETIME — NOT NULL
- BUYER_CD — NVARCHAR(10) — NOT NULL
- BUYER_NAME — NVARCHAR(20) — NOT NULL
- BUYER_EMAIL — NVARCHAR(50) — NOT NULL
- BUYER_PHONE — NVARCHAR(20) — NOT NULL
- NAME — NVARCHAR(20) — NOT NULL
- ZIPCODE — NVARCHAR(10) — NOT NULL
- ADDRESS1 — NVARCHAR(150) — NOT NULL
- ADDRESS2 — NVARCHAR(150) — NOT NULL
- PHONE1 — NVARCHAR(20) — NOT NULL
- PHONE2 — NVARCHAR(20) — NOT NULL
- REMARK — NVARCHAR(300) — NOT NULL
- PAY_TYPE — NCHAR(6) — NOT NULL
- STATUS — NCHAR(6) — NOT NULL
- SYS_ID — NVARCHAR(20) — NOT NULL
- SYS_DT — DATETIME
- AUTO_DELETE_INFO_DT — DATETIME
T_ORDER_PRODUCT
- COLOR_CD — NVARCHAR(10) — Primary key — NOT NULL
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- ITEM_CD — NVARCHAR(20) — NOT NULL
- ITEM_COL — NVARCHAR(50) — NOT NULL
- ITEM_PRICE — INT — NOT NULL
- SELL_PRICE — INT — NOT NULL
- QTY — INT — NOT NULL
- CANCEL_QTY — INT — NOT NULL
- DELIVERY_TYPE — NCHAR(1) — NOT NULL
- DELIVERY_DT — DATETIME
- DELIVERY_NO — NVARCHAR(100) — NOT NULL
- SYS_ID — NVARCHAR(20) — NOT NULL
- SYS_DT — DATETIME
T_ORDER_TEMP
- COLOR_CD — NVARCHAR(10) — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- TEMP_NO — NCHAR(15) — Primary key — NOT NULL
- QTY — INT — NOT NULL
- SYS_DT — DATETIME
T_ORDER_XPAY
- LGD_TID — NCHAR(24) — Primary key — NOT NULL
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- LGD_PAYTYPE — NCHAR(6)
- LGD_PAYDATE — NCHAR(14)
- LGD_FINANCECODE — NVARCHAR(50)
- LGD_FINANCENAME — NVARCHAR(20)
- LGD_FINANCEAUTHNUM — NVARCHAR(20)
- LGD_ACCOUNTNUM — NVARCHAR(20)
- LGD_RESPCODE — NCHAR(4)
- LGD_RESPMSG — NVARCHAR(255)
- SYS_DT — DATETIME
T_ORDER_XPAY_LOG
- LGD_TID — NCHAR(24) — Primary key — NOT NULL
- LGD_TIMESTAMP — NVARCHAR(30) — Primary key — NOT NULL
- ORDER_NO — NCHAR(15) — Primary key — NOT NULL
- RESULT_MSG — NVARCHAR(300) — NOT NULL
- SYS_DT — DATETIME — NOT NULL
T_PEOPLE
- PEOPLE_NO — INT — Primary key — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS_NO — NCHAR(10) — NOT NULL
- PEOPLE_IMG — NVARCHAR(50) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- HITS — INT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_POLICY
- POLICY_NO — INT — Primary key — NOT NULL
- POLICY_TYPE — NVARCHAR(100)
- POLICY_NAME — NVARCHAR(200) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_POLICY_REV
- REV_NO — INT — Primary key — NOT NULL
- POLICY_NO — INT — Foreign key → T_POLICY.POLICY_NO — NOT NULL
- CONTENTS — NTEXT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
- IS_EXPOSED — BIT — NOT NULL
T_POPUP
- ID — INT — Primary key — NOT NULL
- TITLE — NVARCHAR(50) — NOT NULL
- PC_IMG — NVARCHAR(30) — NOT NULL
- MOBILE_IMG — NVARCHAR(30) — NOT NULL
- IMG_DESC — NVARCHAR(max) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME — NOT NULL
- UPD_ID — NVARCHAR(20) — NOT NULL
- UPD_DT — DATETIME — NOT NULL
T_PRODUCT
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- PRODUCT_NAME — NVARCHAR(300) — NOT NULL
- PRODUCT_URL — NVARCHAR(50) — NOT NULL
- CONTENTS_NO — NCHAR(10) — NOT NULL
- NEW_YN — NCHAR(1) — NOT NULL
- BEST_YN — NCHAR(1) — NOT NULL
- DELIVERY_TYPE — NCHAR(1) — NOT NULL
- DIMENSION_IMG — NVARCHAR(50) — NOT NULL
- COMPARE_IMG — NVARCHAR(50) — NOT NULL
- VIDEO_IMG — NVARCHAR(50) — NOT NULL
- VIDEO_URL — NVARCHAR(200) — NOT NULL
- MANUAL_PDF1 — NVARCHAR(50) — NOT NULL
- MANUAL_PDF2 — NVARCHAR(50) — NOT NULL
- SELL_YN — NCHAR(1) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- SELL_HITS — BIGINT — NOT NULL
- VIEW_HITS — BIGINT — NOT NULL
- REG_DT — DATETIME
- REG_ID — NVARCHAR(20) — NOT NULL
- UPD_ID — NVARCHAR(20) — NOT NULL
- UPD_DT — DATETIME — NOT NULL
T_PRODUCT_CATE
- CATE_NO — INT — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- MAIN_YN — NCHAR(1) — NOT NULL
- SEQ — INT — NOT NULL
T_PRODUCT_COLOR
- COLOR_CD — NVARCHAR(10) — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- COLOR_NAME — NVARCHAR(50) — NOT NULL
- ITEM_CD — NVARCHAR(18) — NOT NULL
- ITEM_COL — NVARCHAR(6) — NOT NULL
- STOCK — INT — NOT NULL
- SELL_PRICE — INT — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- MAIN_YN — NCHAR(1) — NOT NULL
- SEQ — INT — NOT NULL
- LIST_IMG — NVARCHAR(50) — NOT NULL
- COLOR_IMG — NVARCHAR(50) — NOT NULL
- PRODUCT_IMG1 — NVARCHAR(50) — NOT NULL
- PRODUCT_IMG2 — NVARCHAR(50) — NOT NULL
- PRODUCT_IMG3 — NVARCHAR(50) — NOT NULL
- PRODUCT_IMG4 — NVARCHAR(50) — NOT NULL
- PRODUCT_IMG5 — NVARCHAR(50) — NOT NULL
- DETAIL_IMG1 — NVARCHAR(50) — NOT NULL
- DETAIL_IMG2 — NVARCHAR(50) — NOT NULL
- DETAIL_IMG3 — NVARCHAR(50) — NOT NULL
- DETAIL_IMG4 — NVARCHAR(50) — NOT NULL
- DETAIL_IMG5 — NVARCHAR(50) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME — NOT NULL
- UPD_ID — NVARCHAR(20) — NOT NULL
- UPD_DT — DATETIME — NOT NULL
T_PRODUCT_DETAIL
- DETAIL_NO — INT — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- DETAIL_URL — NVARCHAR(50) — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS_NO — NCHAR(10) — NOT NULL
- BUTTON_IMG — NVARCHAR(50) — NOT NULL
- TITLE_IMG2 — NVARCHAR(50) — NOT NULL
- SEQ — INT — NOT NULL
T_PRODUCT_ERP
- ITEM_CD — NVARCHAR(18) — Primary key — NOT NULL
- ITEM_COL — NVARCHAR(6) — Primary key — NOT NULL
- ITEM_NAME — NVARCHAR(200) — NOT NULL
- ITEM_PRICE — INT — NOT NULL
- MAKE_PRICE — INT — NOT NULL
- SIZE_DTL — NVARCHAR(200) — NOT NULL
- MATERIAL — NVARCHAR(200) — NOT NULL
- COMPONENT — NVARCHAR(200) — NOT NULL
- COMPANY — NVARCHAR(200) — NOT NULL
- COUNTRY — NVARCHAR(200) — NOT NULL
- IMPORTER — NVARCHAR(200) — NOT NULL
- KC_CERT — NVARCHAR(200) — NOT NULL
- STATUS — NVARCHAR(6) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME — NOT NULL
- UPD_ID — NVARCHAR(20) — NOT NULL
- UPD_DT — DATETIME — NOT NULL
T_PRODUCT_FUNC
- FUNC_NO — INT — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- FUNC_URL — NVARCHAR(50) — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS_NO — NCHAR(10) — NOT NULL
- BUTTON_IMG — NVARCHAR(50) — NOT NULL
- TITLE_IMG2 — NVARCHAR(50) — NOT NULL
- THUMB_IMG — NVARCHAR(50) — NOT NULL
- SEQ — INT — NOT NULL
T_PRODUCT_POPUP
- ID — INT — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — NOT NULL
- POPUP_ID — INT — NOT NULL
- SHOW_YN — BIT — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME — NOT NULL
- UPD_ID — NVARCHAR(20) — NOT NULL
- UPD_DT — DATETIME — NOT NULL
T_PRODUCT_SMART
- COLOR_CD — NVARCHAR(10) — Primary key — NOT NULL
- PRODUCT_CD — NVARCHAR(50) — Primary key — NOT NULL
- PRICE1 — NCHAR(1) — NOT NULL
- PRICE2 — NCHAR(1) — NOT NULL
- PRICE3 — NCHAR(1) — NOT NULL
- PRICE4 — NCHAR(1) — NOT NULL
- PRICE5 — NCHAR(1) — NOT NULL
- USAGE1 — NCHAR(1) — NOT NULL
- USAGE2 — NCHAR(1) — NOT NULL
- USAGE3 — NCHAR(1) — NOT NULL
- USAGE4 — NCHAR(1) — NOT NULL
- USAGE5 — NCHAR(1) — NOT NULL
- BACK1 — NCHAR(1) — NOT NULL
- BACK2 — NCHAR(1) — NOT NULL
- BACK3 — NCHAR(1) — NOT NULL
- BACK4 — NCHAR(1) — NOT NULL
- BACK5 — NCHAR(1) — NOT NULL
- BACK6 — NCHAR(1) — NOT NULL
- SEAT1 — NCHAR(1) — NOT NULL
- SEAT2 — NCHAR(1) — NOT NULL
- SEAT3 — NCHAR(1) — NOT NULL
- SEAT4 — NCHAR(1) — NOT NULL
- SEAT5 — NCHAR(1) — NOT NULL
- SEAT6 — NCHAR(1) — NOT NULL
- AGE1 — NCHAR(1) — NOT NULL
- AGE2 — NCHAR(1) — NOT NULL
- AGE3 — NCHAR(1) — NOT NULL
- AGE4 — NCHAR(1) — NOT NULL
- AGE5 — NCHAR(1) — NOT NULL
- FUNC1 — NCHAR(1) — NOT NULL
- FUNC2 — NCHAR(1) — NOT NULL
- FUNC3 — NCHAR(1) — NOT NULL
- FUNC4 — NCHAR(1) — NOT NULL
- FUNC5 — NCHAR(1) — NOT NULL
- HOUR1 — NCHAR(1) — NOT NULL
- HOUR2 — NCHAR(1) — NOT NULL
- HOUR3 — NCHAR(1) — NOT NULL
- HOUR4 — NCHAR(1) — NOT NULL
- HOUR5 — NCHAR(1) — NOT NULL
- COLOR1 — NCHAR(1) — NOT NULL
- COLOR2 — NCHAR(1) — NOT NULL
- COLOR3 — NCHAR(1) — NOT NULL
- COLOR4 — NCHAR(1) — NOT NULL
- COLOR5 — NCHAR(1) — NOT NULL
- COLOR6 — NCHAR(1) — NOT NULL
- COLOR7 — NCHAR(1) — NOT NULL
- COLOR8 — NCHAR(1) — NOT NULL
- COLOR9 — NCHAR(1) — NOT NULL
- COLOR10 — NCHAR(1) — NOT NULL
- FUNC6 — NCHAR(1)
T_PROPOSAL_REQ
- PROPOSAL_NO — INT — Primary key — NOT NULL
- PROPOSAL_TYPE — NCHAR(6) — NOT NULL
- COMPANY — NVARCHAR(50) — NOT NULL
- PERSON — NVARCHAR(20) — NOT NULL
- POSITION — NVARCHAR(20) — NOT NULL
- PHONE1 — NVARCHAR(50) — NOT NULL
- PHONE2 — NVARCHAR(50) — NOT NULL
- EMAIL — NVARCHAR(50) — NOT NULL
- TITLE — NVARCHAR(200) — NOT NULL
- CONTENTS — NTEXT — NOT NULL
- FILE1 — NVARCHAR(30) — NOT NULL
- FILE2 — NVARCHAR(30) — NOT NULL
- FILE3 — NVARCHAR(30) — NOT NULL
- IP — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME — NOT NULL
- AUTO_DELETE_INFO_DT — DATETIME
T_QNA
- QNA_NO — INT — Primary key — NOT NULL
- QNA_TYPE — NCHAR(6) — NOT NULL
- TITLE — NVARCHAR(300) — NOT NULL
- CONTENTS — NTEXT — NOT NULL
- WRITE_NAME — NVARCHAR(20) — NOT NULL
- WRITE_PHONE — NVARCHAR(50) — NOT NULL
- WRITE_EMAIL — NVARCHAR(50) — NOT NULL
- WRITE_USER_CD — NVARCHAR(10) — NOT NULL
- WRITE_IP — NVARCHAR(20) — NOT NULL
- WRITE_DT — DATETIME
- REPLY_NAME — NVARCHAR(20) — NOT NULL
- REPLY_USER_ID — NVARCHAR(20) — NOT NULL
- REPLY_CONTENTS — NTEXT — NOT NULL
- REPLY_DT — DATETIME
- STATUS — NCHAR(1) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- BUY_PLACE — NVARCHAR(50) — NOT NULL
- BUY_TIME — NVARCHAR(50) — NOT NULL
- WRITE_ADDRESS1 — NVARCHAR(150)
- WRITE_ADDRESS2 — NVARCHAR(150)
- WRITE_ZIPCODE — NVARCHAR(5)
- AUTO_DELETE_INFO_DT — DATETIME
- UPD_ID — NVARCHAR(20) — NOT NULL
- UPD_DT — DATETIME — NOT NULL
T_QNA_FILE
- QNA_NO — INT — Primary key — NOT NULL
- SEQ — INT — Primary key — NOT NULL
- FILE_NO — NVARCHAR(30) — NOT NULL
T_QNA_INACTIVE
- QNA_NO — INT — Primary key — NOT NULL
- QNA_TYPE — NCHAR(6) — NOT NULL
- TITLE — NVARCHAR(300) — NOT NULL
- CONTENTS — NTEXT — NOT NULL
- WRITE_NAME — NVARCHAR(20) — NOT NULL
- WRITE_PHONE — NVARCHAR(50) — NOT NULL
- WRITE_EMAIL — NVARCHAR(50) — NOT NULL
- WRITE_USER_CD — NVARCHAR(10) — NOT NULL
- WRITE_IP — NVARCHAR(20) — NOT NULL
- WRITE_DT — DATETIME
- REPLY_NAME — NVARCHAR(20) — NOT NULL
- REPLY_USER_ID — NVARCHAR(20) — NOT NULL
- REPLY_CONTENTS — NTEXT — NOT NULL
- REPLY_DT — DATETIME
- STATUS — NCHAR(1) — NOT NULL
- SHOW_YN — NCHAR(1) — NOT NULL
- BUY_PLACE — NVARCHAR(50) — NOT NULL
- BUY_TIME — NVARCHAR(50) — NOT NULL
- WRITE_ADDRESS1 — NVARCHAR(150)
- WRITE_ADDRESS2 — NVARCHAR(150)
- WRITE_ZIPCODE — NVARCHAR(5)
- AUTO_DELETE_INFO_DT — DATETIME
T_SERIAL
- DEL_YN — NCHAR(1) — Primary key — NOT NULL
- SERIAL_NO — NVARCHAR(26) — Primary key — NOT NULL
- USER_CD — NCHAR(10) — Primary key — NOT NULL
- ERP_SERIAL_NO — NVARCHAR(26) — NOT NULL
- ITEM_CD — NVARCHAR(20) — NOT NULL
- ITEM_COL — NVARCHAR(10) — NOT NULL
- FR_DT — DATETIME — NOT NULL
- TO_DT — DATETIME — NOT NULL
- GENDER — NVARCHAR(2) — NOT NULL
- AGE — INT — NOT NULL
- PURPOSE — NVARCHAR(200) — NOT NULL
- PLACE — NVARCHAR(200) — NOT NULL
- ROUTE — NVARCHAR(200) — NOT NULL
- REG_DT — DATETIME — NOT NULL
- DEL_DT — DATETIME
T_SNS_INFO
- SNS_ID — NVARCHAR(20) — Primary key — NOT NULL
- SNS_TYPE — NVARCHAR(10) — Primary key — NOT NULL
- USER_CD — NVARCHAR(20) — Foreign key → T_USER.USER_CD — NOT NULL
- REG_DT — DATETIME
T_SNS_INFO_INACTIVE
- SNS_ID — NVARCHAR(20) — Primary key — NOT NULL
- SNS_TYPE — NVARCHAR(10) — Primary key — NOT NULL
- USER_CD — NVARCHAR(20) — Primary key — NOT NULL
- REG_DT — DATETIME
T_STORE
- STORE_NO — INT — Primary key — NOT NULL
- STORE_NAME — NVARCHAR(200) — NOT NULL
- ADDRESS — NVARCHAR(200) — NOT NULL
- TEL_NO — NVARCHAR(50) — NOT NULL
- AREA1 — NCHAR(6) — NOT NULL
- AREA2 — NVARCHAR(6) — NOT NULL
- LOCATION_LAT — NVARCHAR(50) — NOT NULL
- LOCATION_LNG — NVARCHAR(50) — NOT NULL
- BEST_YN — NCHAR(1) — NOT NULL
- DISP_YN — NCHAR(1) — NOT NULL
- EXP_MOLTI_YN — NCHAR(1)
- SHOW_YN — NCHAR(1) — NOT NULL
- STORE_IMG1 — NVARCHAR(50) — NOT NULL
- STORE_IMG2 — NVARCHAR(50) — NOT NULL
- STORE_IMG3 — NVARCHAR(50) — NOT NULL
- STORE_IMG4 — NVARCHAR(50) — NOT NULL
- STORE_IMG5 — NVARCHAR(50) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
- DETAIL_TITLE — NVARCHAR(50)
- DETAIL_CONTENTS — NVARCHAR(500)
- PICKUP_YN — NCHAR(1)
- PARKING_YN — NCHAR(1)
- EVENT_YN — NCHAR(1)
- SEQ — INT
- STREET_NUMBER_ADDRESS — NVARCHAR(200) — NOT NULL
- FLAG_SHOP_YN — NCHAR(1)
- GRAND_OPEN_SHOW_YN — NCHAR(1) — NOT NULL
- GRAND_OPEN_START_DT — DATETIME
- GRAND_OPEN_END_DT — DATETIME
- PARKING_TITLE — NVARCHAR(200)
- PARKING_CONTENT — NVARCHAR(200)
T_STORE_EVENT
- STORE_EVENT_NO — INT — Primary key — NOT NULL
- SHOW_YN — BIT — NOT NULL
- START_DT — DATETIME
- END_DT — DATETIME
- TITLE — VARCHAR(500)
- CONTENT — VARCHAR(500)
- FILE_NO_PC — NVARCHAR(100)
- FILE_NO_MOBILE — NVARCHAR(100)
- URL — NVARCHAR(500)
- TARGET_BLANK_YN — BIT — NOT NULL
- STORE_NO — INT
- EVENT_TYPE — NVARCHAR(10) — NOT NULL
- REG_ID — NVARCHAR(30) — NOT NULL
- REG_DT — DATETIME
- UPD_ID — NVARCHAR(30) — NOT NULL
- UPD_DT — DATETIME
- NAME — NVARCHAR(100)
- SEQ — INT
T_STORE_ONLINE
- STORE_NO — INT — Primary key — NOT NULL
- STORE_NAME — NVARCHAR(200) — NOT NULL
- LINK_URL1 — NVARCHAR(200) — NOT NULL
- LINK_URL2 — NVARCHAR(200)
- LINK_URL3 — NVARCHAR(200)
- LINK_URL4 — NVARCHAR(200)
- TEL_NO — NVARCHAR(50) — NOT NULL
- REG_ID — NVARCHAR(20) — NOT NULL
- REG_DT — DATETIME
T_USER
- USER_CD — NCHAR(10) — Primary key — NOT NULL
- USER_ID — NVARCHAR(200) — NOT NULL
- USER_NAME — NVARCHAR(20) — NOT NULL
- PASSWORD — NVARCHAR(150) — NOT NULL
- BIRTHDAY — NCHAR(8) — NOT NULL
- GENDER — NCHAR(1) — NOT NULL
- EMAIL — NVARCHAR(200) — NOT NULL
- ZIPCODE — NVARCHAR(10) — NOT NULL
- ADDRESS1 — NVARCHAR(200) — NOT NULL
- ADDRESS2 — NVARCHAR(200) — NOT NULL
- PHONE1 — NVARCHAR(50) — NOT NULL
- PHONE2 — NVARCHAR(50) — NOT NULL
- LAST_LOGIN_IP — NVARCHAR(50) — NOT NULL
- LAST_LOGIN_DT — DATETIME
- EMAIL_YN — NCHAR(1) — NOT NULL
- EMAIL_DT — DATETIME
- SMS_YN — NCHAR(1) — NOT NULL
- SMS_DT — DATETIME
- CONFIRM_YN — NCHAR(1) — NOT NULL
- CONFIRM_CD — NVARCHAR(20) — NOT NULL
- CHG_DT — DATETIME
- REG_DT — DATETIME
- LEAVE_YN — NCHAR(1) — NOT NULL
- LEAVE_ID — NVARCHAR(200) — NOT NULL
- LEAVE_DT — DATETIME
- LEAVE_RMK — NVARCHAR(200) — NOT NULL
- LOGIN_CNT — INT
- TERMS_OF_USE_YN — NCHAR(1) — NOT NULL
- TERMS_OF_USE_DT — DATETIME
- PERSONAL_INFO_E_YN — NCHAR(1) — NOT NULL
- PERSONAL_INFO_E_DT — DATETIME
- PERSONAL_INFO_THIRD_YN — NCHAR(1) — NOT NULL
- PERSONAL_INFO_THIRD_DT — DATETIME
- PERSONAL_INFO_S_YN — NCHAR(1) — NOT NULL
- PERSONAL_INFO_S_DT — DATETIME
- DANAL_CI_KEY — NVARCHAR(200)
- CI_DT — DATETIME
- MEMBER_NO — VARCHAR(16)
- MEMBER_STATUS — NCHAR(6) — NOT NULL
- CI_DATA — NVARCHAR(500)
- ERP_SEND_STATUS — VARCHAR(4) — NOT NULL
- UPD_ID — NVARCHAR(20) — NOT NULL
- VENDOR — NVARCHAR(6) — NOT NULL
T_USER_INACTIVE
- USER_CD — NCHAR(10) — Primary key — NOT NULL
- USER_ID — NVARCHAR(200) — NOT NULL
- USER_NAME — NVARCHAR(20) — NOT NULL
- PASSWORD — NVARCHAR(150) — NOT NULL
- BIRTHDAY — NCHAR(8) — NOT NULL
- GENDER — NCHAR(1) — NOT NULL
- EMAIL — NVARCHAR(200) — NOT NULL
- ZIPCODE — NVARCHAR(10) — NOT NULL
- ADDRESS1 — NVARCHAR(200) — NOT NULL
- ADDRESS2 — NVARCHAR(200) — NOT NULL
- PHONE1 — NVARCHAR(50) — NOT NULL
- PHONE2 — NVARCHAR(50) — NOT NULL
- LAST_LOGIN_IP — NVARCHAR(50) — NOT NULL
- LAST_LOGIN_DT — DATETIME
- EMAIL_YN — NCHAR(1) — NOT NULL
- EMAIL_DT — DATETIME
- SMS_YN — NCHAR(1) — NOT NULL
- SMS_DT — DATETIME
- CONFIRM_YN — NCHAR(1) — NOT NULL
- CONFIRM_CD — NVARCHAR(20) — NOT NULL
- CHG_DT — DATETIME
- REG_DT — DATETIME
- LEAVE_YN — NCHAR(1) — NOT NULL
- LEAVE_ID — NVARCHAR(200) — NOT NULL
- LEAVE_DT — DATETIME
- LEAVE_RMK — NVARCHAR(200) — NOT NULL
- LOGIN_CNT — INT
- TERMS_OF_USE_YN — NCHAR(1) — NOT NULL
- TERMS_OF_USE_DT — DATETIME
- PERSONAL_INFO_E_YN — NCHAR(1) — NOT NULL
- PERSONAL_INFO_E_DT — DATETIME
- PERSONAL_INFO_THIRD_YN — NCHAR(1) — NOT NULL
- PERSONAL_INFO_THIRD_DT — DATETIME
- PERSONAL_INFO_S_YN — NCHAR(1) — NOT NULL
- PERSONAL_INFO_S_DT — DATETIME
- DANAL_CI_KEY — NVARCHAR(200)
- CI_DT — DATETIME
- MEMBER_NO — VARCHAR(16)
- MEMBER_STATUS — NCHAR(6) — NOT NULL
- CI_DATA — NVARCHAR(500)
- ERP_SEND_STATUS — VARCHAR(4) — NOT NULL
T_USER_POLICY_LOG
- NO — INT — Primary key — NOT NULL
- USER_CD — NCHAR(10) — Foreign key → T_USER.USER_CD — NOT NULL
- POLICY_NO — INT — NOT NULL
- REV_NO — INT — NOT NULL
- CONSENT_YN — NCHAR(1)
- REG_DT — DATETIME
T_ZIPCODE
- SEQ — NCHAR(3) — Primary key — NOT NULL
- ZIPCODE — NCHAR(6) — Primary key — NOT NULL
- SIDO — NVARCHAR(50) — NOT NULL
- GUGUN — NVARCHAR(50) — NOT NULL
- DONG — NVARCHAR(50) — NOT NULL
- RI — NVARCHAR(50) — NOT NULL
- BUNJI — NVARCHAR(50) — NOT NULL
- BUILDING — NVARCHAR(100) — NOT NULL
- BUNHO — NVARCHAR(50) — NOT NULL
- ADDRESS — NVARCHAR(200) — NOT NULL
- SYS_DT — NCHAR(8) — NOT NULL