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