shared
테이블 (18)
Untitled
- Key — bigint — 기본 키 — NOT NULL
- Key2 — bigint — NOT NULL
- emp_id — bigint — NOT NULL
account
- account_id — bigint — 기본 키 — NOT NULL
- bank_code — varchar(50)
- bank_account — varchar(50)
- beneficiary — varchar(50)
- emp_id — bigint — NOT NULL
annual
- emp_id — bigint — 외래 키 → employee.emp_id — NOT NULL
- annual_remain — int
- reward_remain — int
- updated_at — TIMESTAMP
annual_record
- date — TIMESTAMP — 기본 키 — NOT NULL
- emp_id — bigint — 외래 키 → employee.emp_id — NOT NULL
- type — smallint
- reason — varchar(50)
- rep_id — bigint
- state — boolean
comment
- comment_id — bigint — 기본 키 — NOT NULL
- content — TEXT
- comment_date — TIMESTAMP
- post_id — bigint — NOT NULL
- emp_id — bigint — NOT NULL
company
- company_id — bigint — 기본 키 — NOT NULL
- business_id — varchar(10)
- company_name — varchar(50)
- representitive_name — varchar(50)
- business_type — varchar(5)
- location — varchar(10)
- category — varchar(1)
- phone_number — varchar(50)
- email — varchar(50)
crp
- Key — VARCHAR(255) — 기본 키 — NOT NULL
- company_id2 — int — NOT NULL
- company_id — int — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
dept
- dept_id — bigint — 기본 키 — NOT NULL
- dept_name — varchar(50)
- company_id — int — NOT NULL
employee
- emp_id — bigint — 기본 키 — NOT NULL
- personal_number — varchar(13)
- emp_name — varchar(50)
- hire_date — TIMESTAMP
- end_date — TIMESTAMP
- statement — VARCHAR(255)
- email — varchar(50)
- phone_number — varchar(50)
- Field — varchar(50)
- Field2 — varchar(50)
- absence — boolean
- admin — boolean
- dept_id — int — NOT NULL
employee_salary
- emp_id — bigint — 외래 키 → employee.emp_id — NOT NULL
- salary — BIGINT
- Field — smallint
employee_salary_record
- salary_date — TIMESTAMP — 기본 키 — NOT NULL
- emp_id — bigint — 외래 키 → employee.emp_id — NOT NULL
- Field — BIGINT
- Field2 — BIGINT
file_company
- file_id — bigint — 기본 키 — NOT NULL
- file_name — varchar(255)
- description — TEXT
- file_path — varchar(255)
- upload_date — TIMESTAMP
- company_id — bigint — NOT NULL
irp
- Key — VARCHAR(255) — 기본 키 — NOT NULL
- employee_id2 — int — NOT NULL
- propensity — int
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
post
- post_id — bigint — 기본 키 — NOT NULL
- title — varchar(255)
- content — TEXT
- post_date — TIMESTAMP
- company_id — bigint — NOT NULL
- dept_id — bigint — NOT NULL
- emp_id — bigint — NOT NULL
project
- Key — bigint — 기본 키 — NOT NULL
- project_id — varchar(50)
- description — varchar(50)
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- dept_id — bigint — NOT NULL
- company_id — bigint — NOT NULL
status
- Key — VARCHAR(255) — 기본 키 — NOT NULL
- employee_id — int — NOT NULL
- start_date — varchar(8)
- end_date — varhchar(8)
- status — varchar(1)
- employee_id2 — int — NOT NULL
todo_list
- Key — bigint — 기본 키 — NOT NULL
- due_date — varchar(50)
- end_date — varchar(50)
- start_date — varchar(50)
- state — varchar(1)
- emp_id — bigint — NOT NULL
- Key2 — bigint — NOT NULL