HanEumERD

Tables (9)

average (평균)

  • average_id — BIGINT — Primary key — NOT NULL
  • company_id — VARCHAR — Foreign key → company.company_id — NOT NULL — PK
  • industry_id — BIGINT — Foreign key → industry.industry_id — NOT NULL
  • 업종분류 (category) — VARCHAR
  • 내 점수 (score) — BIGINT
  • 등록일 (created_date) — DATETIME
  • 수정일 (modified_date) — DATETIME

comment (댓글)

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — PK
  • 내용 (content) — LONGTEXT
  • 삭제여부 (is_deleted) — BIT
  • 등록일 (created_date) — DATETIME — NOT NULL
  • 수정일 (modified_date) — DATETIME — NOT NULL

company (회사)

  • company_id — VARCHAR — Primary key — NOT NULL — PK
  • 이름 (name) — VARCHAR — NOT NULL — 필수정보
  • 설립일 (establishment) — VARCHAR — 선택정보
  • 주소 (address) — VARCHAR — 선택정보
  • 고용인원 (employee) — VARCHAR — 선택정보
  • 연매출액 (sales) — VARCHAR — NOT NULL — ROLE_USER, ROLE_ADMIN
  • 자산 (asset) — VARCHAR — NOT NULL — 초기값 = 0
  • 회사소개 (description) — VARCHAR
  • 등록일 (created_date) — DATETIME — NOT NULL
  • 수정일 (modified_date) — DATETIME — NOT NULL

company_analysis (기업분석)

  • growth_id — BIGINT — Primary key — NOT NULL
  • company_id — VARCHAR — Foreign key → company.company_id — NOT NULL — PK
  • 성장성 (growth_rate) — VARCHAR — NOT NULL — 필수정보
  • 효율성 (efficience_rate) — VARCHAR
  • 수익성 (profit_rate) — VARCHAR — NOT NULL
  • 기술력 (technology_rate) — VARCHAR
  • 재무안정성 (stablility_rate) — VARCHAR
  • 등록일 (created_date) — DATETIME
  • 수정일 (modified_date) — DATETIME — NOT NULL

growth (성장 예측)

  • growth_id — BIGINT — Primary key — NOT NULL
  • company_id — VARCHAR — Foreign key → company.company_id — NOT NULL — PK
  • 연도 (year) — BIGINT
  • 값 (sales) — BIGINT
  • 등록일 (created_date) — DATETIME
  • 수정일 (modified_date) — DATETIME

industry (업종)

  • industry_id — BIGINT — Primary key — NOT NULL
  • 평균 (average) — VARCHAR — NOT NULL — 필수정보
  • 상위25프로 평균 (high_average) — VARCHAR
  • 등록일 (created_date) — DATETIME — NOT NULL
  • 수정일 (modified_date) — DATETIME — NOT NULL

member (회원)

  • member_id — BIGINT — Primary key — NOT NULL — PK
  • 이름 (name) — VARCHAR — NOT NULL — 필수정보
  • 이메일 (email) — VARCHAR — NOT NULL — 필수정보
  • 프로필 사진 (picture_url) — VARCHAR — 선택정보
  • 타입 구분 (registration_id) — VARCHAR
  • 등록일 (created_date) — DATETIME — NOT NULL
  • 수정일 (modified_date) — DATETIME — NOT NULL

news (언론)

  • rate_id — BIGINT — Primary key — NOT NULL
  • company_id — VARCHAR — Foreign key → company.company_id — NOT NULL — PK
  • 긍정 비율 (positive_rate) — VARCHAR — NOT NULL — 필수정보
  • 부정 비율 (negeative_rate) — VARCHAR
  • 등록일 (created_date) — DATETIME — NOT NULL
  • 수정일 (modified_date) — DATETIME — NOT NULL

post (커뮤니티)

  • post_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL — PK
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL — PK
  • 제목 (title) — VARCHAR — NOT NULL — 필수정보
  • 내용 (content) — VARCHAR
  • 삭제여부 (is_deleted) — BIT
  • 등록일 (created_date) — DATETIME — NOT NULL
  • 수정일 (modified_date) — DATETIME — NOT NULL