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)