ㄴㅇ
Tables (7)
COMMENT
- id — NUMBER(19) — Primary key — NOT NULL
- post_id — NUMBER(19) — NOT NULL — 게시글
- author — VARCHAR2(100) — NOT NULL — 작성자
- content — CLOB — NOT NULL — 내용
- created_time — TIMESTAMP — NOT NULL — 작성
- like_count — NUMBER — 공감
- parent_comment_id — NUMBER(19) — 부모
COMMUNITY_POST
- id — NUMBER(19) — Primary key — NOT NULL
- category — VARCHAR2(100) — NOT NULL — 카테고리
- title — VARCHAR2(255) — NOT NULL — 제목
- content — CLOB — NOT NULL — 내용
- author — VARCHAR2(100) — NOT NULL — 작성자
- created_time — TIMESTAMP — NOT NULL — 작성
- updated_time — TIMESTAMP — 수정
- view_count — NUMBER — 조회수
- like_count — NUMBER — 공감
COMMUNITY_POST_HASHTAG
- post_id — NUMBER(19) — Primary key — NOT NULL
- hashtag — VARCHAR2(100) — Primary key — NOT NULL — 해시태그
COMMUNITY_POST_JOB_CATEGORY
- post_id — NUMBER(19) — Primary key — NOT NULL
- job_category — VARCHAR2(100) — Primary key — NOT NULL — 직무
COMPANY_PROFILE
- id — NUMBER(19) — Primary key — NOT NULL
- company_name — VARCHAR2(255) — NOT NULL — 기업명
- logo_url — VARCHAR2(500) — 로고
- introduction — CLOB — 기업
- vision — CLOB — 기업
- website — VARCHAR2(255) — 기업
- company_type — VARCHAR2(50) — 기업
- employee_count — NUMBER — 직원
- representative_name — VARCHAR2(100) — 대표자명
- industry — VARCHAR2(100) — 업종
- brand_name — VARCHAR2(100) — 브랜드명
COMPANY_PROFILE_BENEFIT
- profile_id — NUMBER(19) — Primary key — NOT NULL
- benefit — VARCHAR2(100) — Primary key — NOT NULL — 복리후생
WORK_ENVIRONMENT_IMAGE
- id — NUMBER(19) — Primary key — NOT NULL
- profile_id — NUMBER(19) — NOT NULL — 기업
- image_url — VARCHAR2(500) — NOT NULL — 이미지
- title — VARCHAR2(255) — 이미지