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