Study

테이블 (9)

리워드아이템 (reward_item)

  • reward_id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchat(20) — NOT NULL
  • price (Field2) — int — NOT NULL

스터디 (study)

  • study_id (Key) — int — 기본 키 — NOT NULL
  • leader_id (Field7) — int — NOT NULL
  • name (Field) — varchat(20) — NOT NULL
  • category (Field2) — int — NOT NULL
  • max_members (Field3) — int — NOT NULL
  • region (Field4) — varchat(20)
  • start_period (Field5) — DATE — NOT NULL
  • end_period (Field6) — DATE — NOT NULL
  • created_at (Field8) — timestamp — NOT NULL
  • status (Field9) — enum — NOT NULL
  • desctiption (Field10) — varchat(250)
  • region (Field11) — varchat(50)

스터디공지 (study_notify)

  • notify_id (Key) — int — 기본 키 — NOT NULL
  • study_id (Field) — int — NOT NULL
  • title (Field2) — varchat(50) — NOT NULL
  • content (Field3) — varchat(1000) — NOT NULL
  • created_at (Field4) — timestamp — NOT NULL

스터디멤버 (study_member)

  • study_member (Key) — int — 기본 키 — NOT NULL
  • member_id (Field) — int — NOT NULL
  • study_id (Field2) — Int — NOT NULL
  • is_leader (Field3) — boolean — NOT NULL
  • approve (Field4) — boolean — NOT NULL
  • intro (Field5) — varchat(250)

스터디목표 (study_goal)

  • goal_id (Key) — int — 기본 키 — NOT NULL
  • study_id (Field) — int — NOT NULL
  • title (Field2) — varchat(50) — NOT NULL

채팅 (chat)

  • chat (Key) — 기본 키 — NOT NULL
  • Field
  • Field2

퀴즈 (quiz)

  • Quiz (Key) — 기본 키 — NOT NULL
  • Field
  • Field2

회원 (member)

  • member_id (Key) — int — 기본 키 — NOT NULL
  • email (Field) — varchat(255) — NOT NULL
  • nickname (Field2) — varchat(20) — NOT NULL
  • profile_url (Field3) — varchat(250)
  • reward (Field4) — int — NOT NULL
  • provider (Field5) — varchat(20) — NOT NULL
  • created_at (Field6) — timestamp — NOT NULL

획득아이템 (geted_item)

  • reward_id (Key) — int — 기본 키 — NOT NULL
  • member_id (Field) — int — NOT NULL
  • reward_item_id (Field2) — int — NOT NULL