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