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)