homes
Tables (14)
BOARD_MST (공유 메모)
- FAMILY_ID (Key) — Primary key — NOT NULL
- BOARD_ID (Field)
COM_CODE (Untitled3)
- FAMILY_ID (Field) — Primary key
- CODE_GROUP_ID (Field2)
- CODE_ID (Field3)
- CODE_NM (Field4)
DMS_MST (증명서관리)
- FAMILY_ID (Key) — Primary key — NOT NULL
- DMS_ID (Field2) — Primary key
- DMS_TYPE (Field3)
- FILE_ID (Field4)
FAMILIY_MST (가족정보)
- FAMILY_ID (Key) — Primary key — NOT NULL
- DESC (설명)
- REG_ID (Field)
- REG_DT (Field2)
- UPD_ID (Field3)
- UPD_DT (Field4)
FILE_MST (파일관리)
- FAMILY_ID (Key) — Primary key — NOT NULL
- FILE_ID (Key2) — Primary key — NOT NULL
- FILE_PATH (Field2)
- FILE_NM (Field3)
- FILE_TYPE (Field)
SCM_ACCOUNT_MST (계좌정보)
- FAMILY_ID (Key) — Primary key — NOT NULL
- AC_SEQ (Key2) — Primary key — NOT NULL
- OWNER_ID (Field)
- UPD_DT (Field2)
- UPD_ID (Field3)
- REG_DT (Field4)
- REG_ID (Field5)
SCM_ASSET_CONSUMPTION (재산소비등록 리스트)
SCM_ASSET_FORECAST_LIST (재산 예측)
- ASSET_ID (Key) — Primary key — NOT NULL
- FAMILY_ID (Key2) — Primary key — NOT NULL
- FORC_SEQ (Key3) — Primary key — NOT NULL
SCM_ASSET_MST (재산 항목)
- ASSET_ID (Key) — Primary key — NOT NULL
- FAMILY_ID (Key2) — Primary key — NOT NULL
SCM_DEPOSIT_REQUEST_MST (입금요청리스트)
- FAMILY_ID (Key) — Primary key — NOT NULL
- DEP_REQ_SEQ (Key2) — Primary key — NOT NULL
- PUR_ITEM_SEQ (Field)
- STORE_INFO (Field6)
- AMOUNT (Field7)
- REQ_DESC (사유)
- REQ_STATUS (Field8)
- REG_ID (Field2)
- REG_DT (Field3)
- UPD_ID (Field4)
- UPD_DT (Field5)
SCM_PURCHASE_REQUEST_MST (구매요청리스트)
- FAMILY_ID (Key) — Primary key — NOT NULL
- PUR_REQ_SEQ (Key2) — Primary key — NOT NULL
- REQ_DESC (사유)
- REG_ID (Field)
- REG_DT (Field2)
- UPD_ID (Field3)
- UPD_DT (Field4)
SNS_INFO (Untitled2)
- FAMILY_ID (Key) — Primary key — NOT NULL
- POST_ID (Key2) — Primary key — NOT NULL
- FILE_ID (Field)
SNS_MST (Untitled)
- FAMILY_ID (Key) — Primary key — NOT NULL
- POST_ID (Field) — Primary key
- POST_TITLE (Field2)
- POST_CONTENT (Field3)
- POST_TAG (Field4)
USER_MST (유저정보)
- FAMILY_ID (Key2) — Primary key — NOT NULL
- USER_ID (Key) — Primary key — NOT NULL
- USER_PWD (Field)
- USER_NM (Field6)
- USER_PHONE (Field2)
- USER_MAIL (Field3)
- USER_POSITION (Field4)
- USER_AUTH (Field5)