hackathon

테이블 (16)

가능언어 (Languages)

  • language_id (Key) — Bigint — 기본 키 — NOT NULL
  • language (Field) — Varchar(50)

게시글 (Article)

  • article_id (Key) — Bigint — 기본 키 — NOT NULL
  • user_id (Key2) — Bigint — 외래 키 → 유저.user_id — NOT NULL
  • name (Field) — Varchar(50)
  • content (Field2) — Varchar(5000)
  • view (Field3) — Bigint
  • created_at (Field4) — TIMESTAMP

게시글&카테고리 (ArticleCategory)

  • category_id (Key) — Bigint — 외래 키 → 카테고리.category_id — NOT NULL
  • article_id (Key2) — Bigint — 외래 키 → 게시글.article_id — NOT NULL

관할기관 (institution)

  • institution_id (Key) — Bigint — 기본 키 — NOT NULL
  • name (Field) — Varchar(50)
  • title (Field5) — Varchar(50)
  • phone_number (Field2) — Varchar(50)
  • description (Field3) — Varchar(1000)
  • location (Field4) — Varchar(100)

댓글 (Comment)

  • comment_id (Key) — Bigint — 기본 키 — NOT NULL
  • parent_comment_id (Key3) — Bigint — 외래 키 → 댓글.comment_id — NOT NULL
  • article_id (Key1) — Bigint — 외래 키 → 게시글.article_id — NOT NULL
  • user_id (Key2) — Bigint — 외래 키 → 유저.user_id — NOT NULL
  • content (Field) — varchar(5000)
  • created_at (Field2) — TIMESTAMP

비자 (Visa)

  • visa_id (Key) — Bigint — 기본 키 — NOT NULL
  • code (Field) — Varchar(50)
  • name (Field2) — Varchar(50)
  • category (Field3) — Varchar(50)
  • start_at (Field4) — Bigint
  • end_at (Field5) — Bigint

세무사 (Counselors)

  • counselor_id (Key) — Bigint — 기본 키 — NOT NULL
  • name (Field) — Varchar(50)
  • email (Field7) — Varchar(50)
  • phone_number (Field3) — Varchar(50)
  • description (Field2) — Varchar(1000)
  • year (Field4) — Bigint
  • location (Field5) — Varchar(100)

세무사 상담가능 시간 (Time)

  • counselor_id (Key) — Bigint — 외래 키 → 세무사.counselor_id — NOT NULL
  • start_at (Field) — Varchar(50)
  • end_at (Field2) — Varchart(50)
  • Field3

세무사&가능언어 (CounselorLanguages)

  • counselor_id (Key) — Bigint — 외래 키 → 세무사.counselor_id — NOT NULL
  • language_id (Key2) — Bigint — 외래 키 → 가능언어.language_id — NOT NULL

세무사&전문분야 (CounselorSpecialties)

  • counselor_id (Key) — Bigint — 외래 키 → 세무사.counselor_id — NOT NULL
  • specialtie_id (Key2) — Bigint — 외래 키 → 전문분야.specialtie_id — NOT NULL

유저 (Users)

  • user_id (Key) — Bigint — 기본 키 — NOT NULL
  • visa_id (Key2) — Bigint — 외래 키 → 비자.visa_id — NOT NULL
  • password_hash (Field) — Varchar(50)

전문분야 (Specialties)

  • specialtie_id (Key) — Bigint — 기본 키 — NOT NULL
  • specialty (Field) — Varchar(50)

좋아요 (Like)

  • user_id (Key) — Bigint — 외래 키 → 유저.user_id — NOT NULL
  • article_id (Key2) — Bigint — 외래 키 → 게시글.article_id — NOT NULL

카테고리 (Category)

  • category_id (Key) — Bigint — 기본 키 — NOT NULL
  • title (Field) — Varchar(50)

캘린더 (Calender)

  • tax_id (Key) — Bigint — 기본 키 — NOT NULL
  • name (Field) — Varchar(50)
  • description (Field2) — Varchar(1000)
  • day (Field3) — Bigint
  • period (Field4) — Bigint

프로필 (Profiles)

  • user_id (Key2) — Bigint — 외래 키 → 유저.user_id — NOT NULL
  • name (Field3) — Varchar(50)
  • age (Field4) — BIgint
  • nationality (Field5) — Varchar(50)
  • visa_category (Field) — Varchar(50)
  • status (Field2) — Varchar(50)
  • period (Field6) — BIgint
  • work_experience (Field7) — BIgint
  • degree (Field8) — Varchar(50)
  • korean_level (Field9) — Varchar(50)