account project

테이블 (12)

Copy Of Copy Of Copy Of 회원정보 (COMPANY_USERS)

  • Key (COMPANY_USER_ID) — INT — 기본 키 — NOT NULL
  • Key (USER_ID2) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (ROLE) — ENUM
  • Field (STATUS) — ENUM
  • Key (APPOVED_BY) — INT — 외래 키 → Copy Of Copy Of 회원정보.Key — NOT NULL
  • Field (APPROVED_AT) — TIMESTAMP
  • Field (JOINED_AT) — TIMESTAMP

Copy Of Copy Of 회원정보 (USERS)

  • Key (USER_ID) — INT — 기본 키 — NOT NULL
  • Field (EMAIL) — VARCHAR
  • Field (PASSWORD) — VARCHAR
  • Field (NAME) — VARCHAR
  • Field (PHONE) — VARCHAR
  • Field (USER_TYPE) — ENUM
  • Field (IS_ACTIVE) — BOOLEAN
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP
  • Key (PERIOD_ID) — INT — 외래 키 → Untitled.Key — NOT NULL

Copy Of 회원정보 (COMPANIES)

  • Key (COMPANY_ID) — INT — 기본 키 — NOT NULL
  • Field (BUSINESS_NUMBER) — VARCHAR
  • Field (COMPANY_NAME) — VARCHAR
  • Field (CEO_NAME) — VARCHAR
  • Field (ADDRESS) — VARCHAR
  • Field (TEL) — VARCHAR
  • Field (INDUSTRY) — VARCHAR
  • Field (FISCAL_YEAR_END) — VARCHAR
  • Field — DATE
  • Field (IS_ACTIVE) — TINYINT
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (ACCOUNTS)

  • Key (ACCOUNT_ID) — INT — 기본 키 — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (ACCOUNT_CODE) — VARCHAR
  • Field (ACCOUNT_NAME) — VARCHAR
  • Field (ACCOUNT_TYPE) — ENUM
  • Field (ACCOUNT_CATEGORY) — VARCHAR
  • Field (IS_DEBIT_NORMAL) — BOOLEAN
  • Field (IS_SYSTEM) — TINYINT
  • Field (IS_ACTIVE) — BOOLEAN
  • Field (DESCRIPTION) — TEXT
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (CLIENTS)

  • Key (CLIENT_ID) — INT — 기본 키 — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (CLIENT_CODE) — VARCHAR
  • Field (CLIENT_NAME) — VARCHAR
  • Field (BUSINESS_NUMBER) — VARCHAR
  • Field (CEO_NAME) — VARCHAR
  • Field (TEL) — VARCHAR
  • Field (EMAIL) — VARCHAR
  • Field (ADDRESS) — VARCHAR
  • Field (CLIENT_TYPE) — ENUM
  • Field (CATEGORY) — ENUM
  • Field (ACCOUNT_NUMBER) — VARCHAR
  • Field (IS_ACTIVE) — TINYINT
  • Field (CREATE_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (GENERAL_VOUCHERS)

  • Key (VOUCHER_ID) — INT — 기본 키 — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (VOUCHER_DATE) — DATE
  • Field (VOUCHER_NO) — VARCHAR
  • Field (DESCRIPTION) — TEXT
  • Field (TOTAL_DEBIT) — DECIMAL
  • Field (TOTAL_CREDIT) — DECIMAL
  • Field (STATUS) — ENUM
  • Key (CREATED_BY) — INT — 외래 키 → Copy Of Copy Of Copy Of 회원정보.Key — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP
  • Key (COMPANY_ID2) — INT — 외래 키 → Copy Of Copy Of Copy Of 회원정보.Key — NOT NULL

Untitled (GENERAL_VOUCHER_LINES)

  • Key (LINE_ID) — INT — 기본 키 — NOT NULL
  • Key (VOUCHER_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (LINE_NO) — INT
  • Field (VOUCHER_TYPE) — ENUM
  • Field (AMOUNT) — DECIMAL
  • Field (DESCRIPTION_CODE) — VARCHAR
  • Key (ACCOUNT_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (CLIENT_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (DEBIT_AMOUNT) — DECIMAL
  • Field (CREDIT_AMOUNT) — DECIMAL
  • Field (DESCRIPTION) — TEXT
  • Field (CREATED_AT) — TIMESTAMP

Untitled (SALES_PURCHASE_VOUCHERS)

  • Key (VOUCHER_ID) — INT — 기본 키 — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (VOUCHER_DATE) — DATE
  • Field (VOUCHER_TYPE) — ENUM
  • Field (VOUCHER_NO) — VARCHAR
  • Key (CLIENT_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (TAX_INVOICE_YN) — TINYINT
  • Field (TAX_INVOICE_NO) — VARCHAR
  • Field (TOTAL_SUPPLY_AMOUNT) — DECIMAL
  • Field (TOTAL_VAT_AMOUNT) — DECIMAL
  • Field (TOTAL_AMOUNT) — DECIMAL
  • Field (STATUS) — ENUM
  • Field (IS_ACTIVE) — TINYINT
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (FISCAL_PERIODS)

  • Key (PERIOD_ID) — INT — 기본 키 — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (FISCAL_YEAR) — INT
  • Field (START_DATE) — DATE
  • Field (END_DATE) — DATE
  • Field (CURRENT_DISPOSAL_DATE) — DATE
  • Field (PREVIOUS_DISPOSAL_DATE) — DATE
  • Field (IS_CLOSED) — DATETIME
  • Key (CLOSED_BY) — INT — 외래 키 → Copy Of Copy Of 회원정보.Key — NOT NULL
  • Field (CREATE_AT) — DATETIME
  • Field (UPDATED_AT) — DATETIME

Untitled (SALES_PURCHASE_VOUCHERS_LINES)

  • Key (LINE_ID) — INT — 기본 키 — NOT NULL
  • Key (VOUCHER_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (LINE_NO) — INT
  • Field (DEBIT_CREDIT) — ENUM
  • Key (ACCOUNT_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (CLIENT_ID) — INT
  • Field (AMOUNT) — DECIMAL
  • Field (DESCRIPTION) — TEXT
  • Field (DESCRIPTION_CODE) — VARCHAR
  • Field (DEPARTMENT_CODE) — VARCHAR
  • Field (CREATED_AT) — TIMESTAMP

Untitled (CARRY_FORWARD_BALANCES)

  • Key (BALANCE_ID) — INT — 기본 키 — NOT NULL
  • Key (COMPANY_ID) — INT — 외래 키 → Copy Of 회원정보.Key — NOT NULL
  • Field (FISCAL_YEAR) — INT
  • Key (ACCOUNT_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (CLIENT_ID) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (DEBIT_BALANCE) — DECIMAL
  • Field (CREDIT_BALANCE) — DECIMAL
  • Field2 (CREATED_AT) — TIMESTAMP

Untitled (SYSTEM_ACCOUNTS)

  • Key (SYSTEM_ACCOUNT_ID) — INT — 기본 키 — NOT NULL
  • Field (ACCOUNT_CODE) — VARCHAR
  • Field (ACCOUNT_NAME) — VARCHAR
  • Field (ACCOUNT_TYPE) — ENUM
  • Field (ACCOUNT_CATEGORY) — VARCHAR
  • Field (IS_DEBIT_NORMAL) — TINYINT
  • Field (DESCRIPTION) — TEXT
  • Field (CREATED_AT) — TIMESTAMP