고급 프로젝트

테이블 (21)

account_userwithdraw (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • reason (Field)
  • created_at (Field2)

accounts_attendance (Untitled3)

  • Key2 — 기본 키 — NOT NULL
  • user_id (Key) — 외래 키 → user.id — NOT NULL
  • attendance_date_list (Field)

accounts_blockrecord (CopyOfUntitled3)

  • id (Key3) — 기본 키 — NOT NULL
  • user_id (Key) — 외래 키 → user.id — NOT NULL
  • block_user_id (Key2) — 외래 키 → user.id — NOT NULL
  • reason (Field2)
  • created_at (Field3)

accounts_failpaymenthistory (CopyOfCopyOfUntitled3)

  • id (Key2) — 기본 키 — NOT NULL
  • user_id (Key) — 외래 키 → user.id — NOT NULL
  • product_id (Field)
  • phone_type (Field2)
  • created_at (Field3)

accounts_friendrequest (Untitled15)

  • id (Key) — 기본 키 — NOT NULL
  • send_user_id (Key2) — 외래 키 → user.id — NOT NULL
  • receive_user_id (Key3) — 외래 키 → user.id — NOT NULL
  • status (Field2)
  • created_at (Field)
  • updated_at (Field3)

accounts_group (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • grade (Field)
  • class_num (Field2)
  • school_id (Key2) — 외래 키 → accounts_school.id — NOT NULL

accounts_nearbyschool (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • school_id (Key2) — 외래 키 → accounts_school.id — NOT NULL
  • nearby_school_id (Key3) — 외래 키 → accounts_school.id — NOT NULL
  • distance (Field)

accounts_paymenthistory (Untitled6)

  • id (Key2) — 기본 키 — NOT NULL
  • user_id (Key) — 외래 키 → user.id — NOT NULL
  • product_id (Field)
  • phone_type (Field2)
  • created_at (Field3)

accounts_pointhistory (Untitled8)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → user.id — NOT NULL

accounts_school (Untitled13)

  • id (Key) — 기본 키 — NOT NULL
  • address (Field)
  • school_type (Field2)
  • student_count (Field3)

accounts_timelinereport (Untitled14)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → user.id — NOT NULL
  • user_question_record_id (Key3) — 외래 키 → accounts_userquestionrecord.id — NOT NULL
  • user_id (Key4) — 외래 키 → user.id — NOT NULL
  • Field
  • Field2

accounts_user_contacts (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • count (Field)
  • user_id (Key2) — 외래 키 → user.id — NOT NULL
  • invite_user_id_list (Key3) — 외래 키 → user.id — NOT NULL

accounts_userquestionrecord (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • question_id (Key4) — 외래 키 → polls_question.id — NOT NULL
  • user_id (Key2) — 외래 키 → user.id — NOT NULL
  • chosen_user_ud (Key3) — 외래 키 → user.id — NOT NULL
  • question_piece_id (Key5) — 외래 키 → polls_questionpiece.id — NOT NULL
  • opened_times (Field)
  • status (Field2)
  • answer_status (Field3)
  • answer_updated_at (Field4)
  • report_count (Field5)
  • has_read (Field6)
  • created_at (Field7)

event_receipts (Untitled11)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → user.id — NOT NULL
  • event_id (Key3) — 외래 키 → events.id — NOT NULL
  • plus_point (Field)
  • created_at (Field2)

events (Untitled12)

  • id (Key) — 기본 키 — NOT NULL
  • title (Field)
  • plus_point (Field2)
  • is_expired (Field3)
  • created_at (Field4)
  • event_type (Field5)

polls_question (질문 데이터 테이블)

  • id (Key) — 기본 키 — NOT NULL
  • question_text (Field)
  • created_at (Field2)

polls_questionpiece (질문조각)

  • id (Key) — 기본 키 — NOT NULL
  • question_id (Key2) — 외래 키 → polls_question.id — NOT NULL
  • is_voted (Field)
  • is_skipped (Field2)
  • created_at (Field3)

polls_questionreport (질문에 대한 신고기록 테이블)

  • id (Key) — 기본 키 — NOT NULL
  • question_id (Key2) — 외래 키 → polls_question.id — NOT NULL
  • user_id (Field)
  • reason (Field2)
  • created_at (Field3)

polls_questionset (질문 세트 테이블)

  • id (Key) — 기본 키 — NOT NULL
  • question_piece_id_list (Key2) — 외래 키 → polls_questionpiece.id — NOT NULL
  • opening_time (Field)
  • status (Field2)
  • created_at (Field3)

polls_usercandidate (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • question_piece_id (Key2) — 외래 키 → polls_questionpiece.id — NOT NULL
  • user_id (Key3) — 외래 키 → user.id — NOT NULL
  • created_at (Field2)

user (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • is_superuser (Field)
  • is_staff (Field2)
  • firebase_uid (Field3)
  • gender (Field4)
  • point (Field5)
  • friend_id_list (Field6)
  • hide_user_id_list (Field7)
  • ban_status (Field8)
  • report_count (Field9)
  • alarm_count (Field10)
  • pending_chat (Field11)
  • pending_votes (Field12)
  • group_id (Key2) — 외래 키 → accounts_group.id — NOT NULL
  • created_at (Field13)