ggbb
Tables (24)
TB_APP_PUSH
- ID — bigint — Primary key — NOT NULL
- APP_PUSH_MAST_ID — bigint
- BODY — varchar(500) — NOT NULL
- IMAGE_URL — varchar(500)
- REG_DT — datetime(6)
- SEND_DT — datetime(6)
- SEND_YN — varchar(1) — NOT NULL
- STATUS — varchar(20)
- TITLE — varchar(100) — NOT NULL
TB_APP_PUSH_MAST
- ID — bigint — Primary key — NOT NULL
- FCM_TYPE — varchar(50) — NOT NULL
- MEMBER_ID — bigint
- PUSH_TYPE — varchar(50) — NOT NULL
- REG_DT — datetime(6)
TB_APP_PUSH_MGMT
- APP_PUSH_TYPE — enum('LINK_SUCCESS','MONEY_BOOK_WRITTEN','TODAY_NOTHING') — Primary key — NOT NULL
- DISPLAY_ORDER — int
- DISPLAY_YN — varchar(255)
TB_APP_VERSION_POLICY
- ID — bigint — Primary key — NOT NULL
- FORCE_UPDATE_YN — varchar(1) — NOT NULL
- LATEST_VERSION — varchar(50) — NOT NULL
- MIN_VERSION — varchar(50) — NOT NULL
- OS_TYPE — varchar(50) — NOT NULL
- REG_DT — datetime(6)
- STORE_URL — varchar(200) — NOT NULL
- UPDATE_DT — datetime(6)
TB_ASSET
- ID — bigint — Primary key — NOT NULL
- ASSET_GROUP_ID — bigint
- BALANCE — bigint
- DELETE_YN — varchar(1)
- DESCRIPTION — varchar(1000)
- MONEY_BOOK_ID — bigint
- NAME — varchar(200)
- REG_DT — datetime(6)
- UPDATE_DT — datetime(6)
- CURRENCY_CODE — varchar(3)
TB_ASSET_GROUP
- ID — bigint — Primary key — NOT NULL
- DELETE_YN — varchar(1)
- MONEY_BOOK_ID — bigint
- NAME — varchar(200)
- REG_DT — datetime(6)
- TYPE — varchar(20)
- UPDATE_DT — datetime(6)
TB_BOARD
- ID — bigint — Primary key — NOT NULL
- BOARD_TYPE — varchar(10)
- CONTENT — text
- CONTENT_TYPE — varchar(30)
- REG_DT — datetime(6)
- TITLE — varchar(500)
- UPDATE_DT — datetime(6)
- USE_YN — varchar(1)
TB_BUDGET
- ID — bigint — Primary key — NOT NULL
- AMOUNT — bigint
- BASE_YM — varchar(6)
- CATEGORY_ID — bigint
- MONEY_BOOK_ID — bigint
- REG_DT — datetime(6)
- UPDATE_DT — datetime(6)
TB_CATEGORY
- ID — bigint — Primary key — NOT NULL
- DELETE_YN — varchar(1)
- DISPLAY_ORDER — int — NOT NULL
- MONEY_BOOK_ID — bigint
- NAME — varchar(200)
- REG_DT — datetime(6)
- TYPE — varchar(15)
- UPDATE_DT — datetime(6)
TB_CURRENCY
- CURRENCY_CODE — varchar(3) — Primary key — NOT NULL
- DECIMAL_PLACES — int
- DISPLAY_ORDER — int
- IS_ACTIVE — bit(1)
- NAME — varchar(50)
- SYMBOL — varchar(10)
TB_GROUP
- ID — bigint — Primary key — NOT NULL
- OWNER_MEMBER_ID — bigint
- REG_DT — datetime(6)
- UPDATE_DT — datetime(6)
- WEDDING_ANNIVERSARY — varchar(8)
TB_LINK_CODE
- ID — bigint — Primary key — NOT NULL
- BASE_DAY — varchar(8) — NOT NULL
- LINK_CODE — varchar(8) — NOT NULL
- REG_DT — datetime(6)
- STATUS — varchar(1) — NOT NULL
- UPDATE_DT — datetime(6)
- GROUP_ID — bigint — Foreign key → TB_GROUP.ID
TB_MEMBER
- ID — bigint — Primary key — NOT NULL
- BIRTHDAY — varchar(8)
- EMAIL — varchar(200) — NOT NULL
- NICKNAME — varchar(100) — NOT NULL
- PASSWORD — varchar(255) — NOT NULL
- REG_DT — datetime(6)
- ROLE — varchar(20)
- STATUS — varchar(1)
- UPDATE_DT — datetime(6)
- USE_YN — varchar(1)
- GROUP_ID — bigint — Foreign key → TB_GROUP.ID
TB_MEMBER_APP
- MEMBER_ID — bigint — Primary key — NOT NULL
- APP_VERSION — varchar(50)
- OS_NAME — varchar(200)
- OS_VERSION — varchar(50)
- PUSH_TOKEN — varchar(255)
- REG_DT — datetime(6)
- UPDATE_DT — datetime(6)
TB_MEMBER_PUSH_SET
- APP_PUSH_TYPE — varchar(50) — Primary key — NOT NULL
- MEMBER_ID — bigint — Primary key — NOT NULL
- IS_ENABLED — bit(1) — NOT NULL
- REG_DT — datetime(6)
- UPDATE_DT — datetime(6)
TB_MONEY_BOOK
- ID — bigint — Primary key — NOT NULL
- NAME — varchar(255)
- GROUP_ID — bigint — Foreign key → TB_GROUP.ID
TB_MONEY_BOOK_MGMT
- NAME — varchar(255) — Primary key — NOT NULL
- DEFAULT_VALUE — varchar(255)
- DISPLAY_NAME — varchar(255)
- DISPLAY_ORDER — int
TB_MONEY_BOOK_RECORD
- ID — bigint — Primary key — NOT NULL
- ADDITIONAL_INFO — varchar(4000)
- AMOUNT — bigint
- ASSET_ID — bigint
- BASE_DAY — varchar(8)
- CATEGORY_ID — bigint
- CURRENCY — varchar(3)
- DEPOSIT_ASSET_ID — bigint
- DESCRIPTION — varchar(500)
- LAST_MODIFY_MEMBER_ID — bigint
- MONEY_BOOK_ID — bigint
- RECORD_TYPE — varchar(20)
- REG_DT — datetime(6)
- SUBJECT_ID — bigint
- UPDATE_DT — datetime(6)
- WITHDRAW_ASSET_ID — bigint
- WRITER_MEMBER_ID — bigint
- DELETE_YN — varchar(1)
TB_MONEY_BOOK_SET
- MONEY_BOOK_ID — bigint — Primary key — NOT NULL
- NAME — varchar(50) — Primary key — NOT NULL
- VALUE — varchar(100)
TB_SUBJECT
- ID — bigint — Primary key — NOT NULL
- DELETE_YN — varchar(1)
- ICON — varchar(200)
- MONEY_BOOK_ID — bigint
- NAME — varchar(200)
- REG_DT — datetime(6)
- UPDATE_DT — datetime(6)
TB_SUBJECT_ICON
- ICON — varchar(255) — Primary key — NOT NULL
- DISPLAY_ORDER — int
TB_TERMS
- ID — bigint — Primary key — NOT NULL
- CONTENT — text
- DISPLAY_ORDER — int
- END_DAY — varchar(8)
- REG_DT — datetime(6)
- REQUIRED_YN — varchar(1)
- START_DAY — varchar(8)
- TITLE — varchar(500)
- UPDATE_DT — datetime(6)
- USE_YN — varchar(1)
- TERMS_TYPE — varchar(10)
- CONTENT_TYPE — varchar(100)
- LINK — varchar(1000)
TB_TERMS_AGREE
- ID — bigint — Primary key — NOT NULL
- AGREE_YN — varchar(1)
- MEMBER_ID — bigint
- REG_DT — datetime(6)
- TERMS_ID — bigint
- UPDATE_DT — datetime(6)
TB_TERMS_AGREE_HIST
- ID — bigint — Primary key — NOT NULL
- AGREE_YN — varchar(1)
- MEMBER_ID — bigint
- REG_DT — datetime(6)
- TERMS_ID — bigint