algo-study

테이블 (3)

미션 (mission)

  • mission_id (PK) — bigint — 기본 키 — NOT NULL
  • topic (Field) — varchar
  • description (Field2) — varchar
  • deadline (Field3) — timestamp
  • auth_explanation (Field5) — varchar
  • auth_frequency (Field4) — varchar
  • Field6

스터디 그룹 (study_gruop)

  • group_id (PK) — bigint — 기본 키 — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • target (Field4) — varchar
  • enrollment_capacity (Field5) — int
  • is_public (Field6) — boolean

회원 (user)

  • user_id (PK) — bigint — 기본 키 — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar