moai
테이블 (7)
Copy Of Untitled (EXPENSE)
- Key (EXPENSE_ID) — BIGINT — 기본 키 — NOT NULL
- Key (BUDGET_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (TYPE) — VARCHAR(50)
- Field (CATEGORY) — VARCHAR(100)
- Field (DESCRIPTION) — VARCHAR(500)
- Field2 (CURRENCY_TYPE) — VARCHAR(50)
- Field (AMOUNT) — DECIMAL(15,2)
- Field (FREQUENCY_TYPE) — VARCHAR(100)
- Field (EXPENSE_DD) — DATE
- Field (REG_ID) — BIGINT
- Field (REG_DT) — DATETIME
Untitled (BUDGET)
- Key (BUDGET_ID) — BIGINT — 기본 키 — NOT NULL
- Field (TITLE) — TEXT
- Field2 (DESCRIPTION) — LONGTEXT
- Field3 (USE_YN) — CHAR(1)
- Field4 (REG_ID) — BIGINT
- Field5 (REG_DT) — DATETIME
Untitled (BUDGET_MEMBER)
- 사용자 ID (USER_ID) — BIGINT — 외래 키 → 사용자.사용자 ID — NOT NULL
- Key (BUDGET_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (ROLE) — VARCHAR(20) — NOT NULL
- Field (ACCEPT_YN) — CHAR(1)
- Field (JOIN_DT) — DATETIME
Untitled (INCOME)
- Key (INCOME_ID) — BIGINT — 기본 키 — NOT NULL
- Key (BUDGET_ID) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (CATEGORY) — VARCHAR(100)
- Field (DESCRIPTION) — VARCHAR(500)
- Field2 (CURRENCY_TYPE) — VARCHAR(50)
- Field (AMOUNT) — DECIMAL(15,2)
- Field (FREQUENCY_TYPE) — VARCHAR(100)
- Field (INCOME_DD) — DATE
- Field (REG_ID) — BIGINT
- Field (REG_DT) — DATETIME
Untitled (QUESTION)
- Key (QUESTION_ID) — INT — 기본 키 — NOT NULL
- Field (ORDER_NO) — INT
- Field (QUESTION) — LONGTEXT
Untitled (CATEGORY)
- Key (CATEGORY_ID) — INT — 기본 키 — NOT NULL
- Field (CATEGORY_CD) — VARCHAR(50)
- Field (CATEGORY_NM) — VARCHAR(50)
- Field (PLACE_HOLDER) — VARCHAR(500)
사용자 (USERS)
- 사용자 ID (USER_ID) — BIGINT — 기본 키 — NOT NULL
- 로그인유형 (OAUTH_TYPE) — VARCHAR(20)
- Field2 (EMAIL) — VARCHAR(300)
- Field3 (NICKNAME) — VARCHAR(100)
- Field4 (ACCESS_TOKEN) — VARCHAR(500)
- Field (REFRESH_TOKEN) — VARCHAR(500)
- Field (LOGIN_DT) — DATETIME
- Field (REG_DT)