fitme

Tables (9)

alarm (알림)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • type (Field) — enum — matching_post, deadline_reminder
  • is_enabled (Field2) — boolean

category (카테고리)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — enum — 마케팅, 기획/아이디어, 영상, IT, 디자인, 어학

inquiry (문의)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — date
  • Field3

journal (이력 기록장)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • advertise_id (FK2) — bigint — Foreign key → post.id — NOT NULL
  • state (Field) — enum — 결과대기중, 서류합격, 최종합격
  • memo (Field2) — text
  • created_at (Field3) — date
  • modified_at (Field4) — date
  • deleted_at (Field5) — date

notification (공지사항)

  • id (Key) — bigint — Primary key — NOT NULL
  • type (Field) — enum — 안내, 점검
  • title (Field2) — varchar(100)
  • date (Field3) — varchar(100)
  • text (Field4) — varchar(250)

post (공고)

  • id (Key) — bigint — Primary key — NOT NULL
  • type (Field) — enum — 장학금, 공모전
  • title (Field2) — varchar(100)
  • host (Field3) — varchar(20)
  • deadline (Field4) — date
  • detail (Field5) — text
  • url (Field6) — varchar(250)
  • created_at (Field7) — date

save_ad (찜 공고)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • advertise_id (FK2) — bigint — Foreign key → post.id — NOT NULL

user (회원)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • birth (Field2) — date
  • email (Field3) — email
  • password (Field4) — varchar(10)
  • provider (Field5) — varchar(10)
  • provider_id (Field6) — varchar(100)
  • region (Field7) — enum
  • university (Field8) — enum
  • student_num (Field11) — int
  • gpa (Field9) — float
  • income_range (Field10) — int
  • created_at (Field12) — date
  • modified_at (Field13) — date
  • deleted_at (Field14) — date — soft delet (30일 뒤 삭제)

user_category (회원 선호 카테고리)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • category_id (FK2) — bigint — Foreign key → category.id — NOT NULL