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