ㄴㅇ

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) — 이미지