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

개발단계에서