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)