playdata 커뮤니티

테이블 (19)

CAMPUS (학원 정보)

  • campus_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(100)
  • Field2 — VARCHAR(255)
  • Field3

CATEGORY (카테고리)

  • category_id (Key) — BIGINT — 기본 키 — NOT NULL
  • parent_id (Field) — BIGINT
  • name (Field2) — VARCHAR(100)
  • slug (Field3) — VARCHAR(100)
  • category_type (Field4) — VARCHAR(30)
  • sort_order (Field5) — INT
  • is_active (Field6) — BOOLEAN

CERTIFICATE (자격증)

  • certificate_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(150)
  • organizer (Field2) — VARCHAR(150)
  • official_url (Field3) — VARCHAR(500)
  • Field4 — BOOLEAN

CERTIFICATE_REVIEW (자격증 후기)

  • certificate_Review_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • certificate_id (Field2) — BIGINT
  • exam_round (Field3) — VARCHAR(30)
  • score (Field4) — VARCHAR(50)
  • study_period (Field5) — VARCHAR(50)
  • study_method (Field6) — TEXT
  • materials (Field7) — TEXT
  • tips (Field8) — TEXT

CERTIFICATE_SCHEDULE (자격증 일정)

  • schedule_id (Key) — BIGINT — 기본 키 — NOT NULL
  • certificate_id (Field) — BIGINT
  • exam_year (Field2) — SMALLINT
  • round (Field3) — VARCHAR(30)
  • application_start (Field4) — DATE
  • application_end (Field5) — DATE
  • exam_date (Field6) — DATE
  • result_date (Field7) — DATE
  • Field8 — VARCHAR(30)

COMMENT (게시글)

  • comment_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • discord_user_id (Field2) — VARCHAR(30)
  • parent_comment_id (Field3) — BIGINT
  • content (Field4) — TEXT
  • status (Field5) — VARCHAR(20)
  • created_at (Field6) — DATETIME

COMPANY (취업 회사)

  • company_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(200)
  • industry (Field2) — VARCHAR(100)
  • website_url (Field3) — VARCHAR(500)

CRAWL_SOURCE (크롤링 소스)

  • source_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(150)
  • base_url (Field2) — VARCHAR(500)
  • source_type (Field3) — VARCHAR(20)
  • is_active (Field4) — BOOLEAN
  • last_crawled_at (Field5) — DATETIME

DISCORD_MEMBER (디스코드 멤버)

  • discord_user_id (Key) — VARCHAR(30) — 기본 키 — NOT NULL
  • username (Field) — VARCHAR(100)
  • display_name (Field2) — VARCHAR(100)
  • campus_id (Field3) — BIGINT
  • last_synced_at (Field4) — DATETIME

EMPLOYMENT_REVIEW (취업 후기 리뷰)

  • employment_review_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • company_id (Field2) — BIGINT
  • job_title (Field3) — VARCHAR(150)
  • preparation_period (Field4) — VARCHAR(50)
  • preparation_process (Field5) — TEXT
  • recruitment_process (Field6) — TEXT
  • interview_review (Field7) — TEXT
  • review (Field8) — LONGTEXT
  • employment_date (Field9) — DATE

IT_NEWS (IT NEWS 정보)

  • news_id (Key) — BIGINT — 기본 키 — NOT NULL
  • source_id (Field) — BIGINT
  • external_id (Field2) — VARCHAR(150)
  • title (Field3) — VARCHAR(500)
  • summary (Field4) — TEXT
  • thumbnail_url (Field5) — VARCHAR(1000)
  • original_url (Field6) — VARCHAR(1000)
  • published_at (Field7) — DATETIME
  • crawled_at (Field8) — DATETIME

JOB_POSTING (취업 정보 크롤링 테이블)

  • job_id (Key) — BIGINT — 기본 키 — NOT NULL
  • source_id (Field) — BIGINT
  • company_id (Field2) — BIGINT
  • external_id (Field3) — VARCHAR(150)
  • company_name_raw (Field4) — VARCHAR(200)
  • title (Field5) — VARCHAR(500)
  • job_category (Field6) — VARCHAR(150)
  • carrer_type (Field7) — VARCHAR(50)
  • location (Field8) — VARCHAR(150)
  • deadline (Field9) — DATETIME
  • original_url (Field10) — VARCHAR(1000)
  • published_at (Field11) — DATETIME
  • crawled_at (Field12) — DATETIME

LOST_FOUND (분실 / 습득물 테이블)

  • lost_found_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • compus_id (Field2) — BIGINT
  • type (Field3) — VARCHAR(10)
  • item_name (Field4) — VARCHAR(150)
  • location (Field5) — VARCHAR(255)
  • event_date (Field6) — DATE
  • resolved (Field7) — BOOLEAN
  • resolved_at (Field8) — DATETIME

MEETING (모임 카테고리)

  • meeting_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • meeting_type (Field2) — VARCHAR(20)
  • topic_name (Field3) — VARCHAR(150)
  • max_members (Field4) — INT
  • deadline (Field5) — DATETIME
  • meeting_date (Field6) — DATETIME
  • location (Field7) — VARCHAR(255)
  • online_url (Field8) — VARCHAR(500)
  • price (Field9) — DECIMAL(12, 2)
  • status (Field10) — VARCHAR(20)

MEETING_MEMBER (모임 멤버)

  • meeting_member_id (Key) — BIGINT — 기본 키 — NOT NULL
  • meetind_id (Field) — BIGINT
  • discord_user_id (Field2) — VARCHAR(30)
  • status (Field3) — VARCHAR(20)
  • joind_at (Field4) — DATETIME

POST (게시글 속 내용)

  • post_id (Key) — BIGINT — 기본 키 — NOT NULL
  • discord_user_id (Field) — VARCHAR(30)
  • category_id (Field2) — BIGINT
  • title (Field3) — VARCHAR(255)
  • content (Field4) — LONGTEXT
  • view_count (Field5) — INT
  • status (Field6) — VARCHAR(20)
  • created_at (Field7) — DATETIME
  • updated_at (Field8) — DATETIME

POST_ATTACHMENT (게시글 속 첨부파일)

  • attachment_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • file_name (Field2) — VARCHAR(255)
  • file_url (Field3) — VARCHAR(500)
  • file_type (Field4) — VARCHAR(100)
  • created_at (Field5) — DATETIME

POST_LIKE (Untitled)

  • post_id (Key) — BIGINT — 기본 키 — NOT NULL
  • discord_user_id (Field) — VARCHAR(30)
  • cerated_at (Field2) — DATETIME

RESTAURANT_INFO (Untitled2)

  • restaurant_info_id (Key) — BIGINT — 기본 키 — NOT NULL
  • post_id (Field) — BIGINT
  • campus_id (Field2) — BIGINT
  • restaurant_name (Field3) — VARCHAR(150)
  • food_category (Field4) — VARCHAR(50)
  • address (Field5) — VARCHAR(255)
  • recommended_menu (Field6) — VARCHAR(255)
  • prince_range (Field7) — VARCHAR(50)
  • rating (Field8) — DECIMAL(2,1)