asd

Tables (4)

EXPENSE (지출)

  • KEY (id) — INT — Primary key — NOT NULL
  • user_id (user) — VARCHAR — Foreign key → USER.KEY — NOT NULL
  • method_id (method) — INT — Foreign key → PAYMENT_METHOD.user_id — NOT NULL
  • (category) — ENUM
  • (amount) — INT
  • (contents) — VARCHAR
  • (created_at) — DATETIME

INCOME (수입)

  • KEY (id) — INT — Primary key — NOT NULL
  • user_id (user) — VARCHAR — Foreign key → USER.KEY — NOT NULL
  • (category) — ENUM
  • (amount) — INT
  • (source) — VARCHAR
  • (created_at) — DATETIME

PAYMENT_METHOD (결제수단)

  • KEY (id) — INT — Primary key — NOT NULL
  • user_id (user) — VARCHAR — Foreign key → USER.KEY — NOT NULL
  • (method) — VARCHAR — NOT NULL

USER (사용자)

  • KEY (id) — VARCHAR — Primary key — NOT NULL
  • (name) — VARCHAR
  • (password) — VARCHAR
  • (salt) — VARCHAR