1팀_고급프로젝트SNS_ERD

고급 프로젝트_1팀

테이블 (25)

accounts_attendance

  • id — bigint — 기본 키 — NOT NULL
  • attendance_date_list — longtext — NOT NULL
  • user_id — bigint — 외래 키 → accounts_user.id — NOT NULL

accounts_blockrecord

  • id — bigint — 기본 키 — NOT NULL
  • reason — varchar(50) — NOT NULL
  • created_at — datetime
  • block_user_id — bigint — 외래 키 → accounts_user.id — NOT NULL
  • user_id — bigint — 외래 키 → accounts_user.id — NOT NULL

accounts_failpaymenthistory

  • id — bigint — 기본 키 — NOT NULL
  • productId — varchar(100)
  • phone_type — varchar(1) — NOT NULL
  • created_at — datetime
  • user_id — bigint — 외래 키 → accounts_user.id — NOT NULL

accounts_friendrequest

  • id — bigint — 기본 키 — NOT NULL
  • status — varchar(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • receive_user_id — bigint — 외래 키 → accounts_user.id — NOT NULL
  • send_user_id — bigint — 외래 키 → accounts_user.id — NOT NULL

accounts_group

  • id — bigint — 기본 키 — NOT NULL
  • grade — int — NOT NULL
  • class_num — int — NOT NULL
  • school_id — bigint — NOT NULL

accounts_nearbyschool

  • id — bigint — 기본 키 — NOT NULL
  • distance — double — NOT NULL
  • nearby_school_id — bigint — 외래 키 → accounts_school.id — NOT NULL
  • school_id — bigint — 외래 키 → accounts_school.id — NOT NULL

accounts_paymenthistory

  • id — bigint — 기본 키 — NOT NULL
  • productId — varchar(100) — NOT NULL
  • phone_type — varchar(1) — NOT NULL
  • created_at — datetime
  • user_id — bigint — 외래 키 → accounts_user.id — NOT NULL

accounts_pointhistory

  • id — bigint — 기본 키 — NOT NULL
  • delta_point — int — NOT NULL
  • created_at — datetime
  • user_id — bigint — NOT NULL
  • user_question_record_id — bigint — 외래 키 → accounts_userquestionrecord.id

accounts_school

  • id — bigint — 기본 키 — NOT NULL
  • address — varchar(100) — NOT NULL
  • student_count — int — NOT NULL
  • school_type — varchar(1) — NOT NULL

accounts_timelinereport

  • id — bigint — 기본 키 — NOT NULL
  • reason — varchar(50) — NOT NULL
  • created_at — datetime
  • reported_user_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • user_question_record_id — bigint — 외래 키 → accounts_userquestionrecord.id — NOT NULL

accounts_user

  • id — bigint — 기본 키 — NOT NULL
  • is_superuser — tinyint(1) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • gender — varchar(1)
  • point — int — NOT NULL
  • friend_id_list — longtext
  • is_push_on — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • block_user_id_list — longtext
  • hide_user_id_list — longtext
  • ban_status — varchar(2) — NOT NULL
  • report_count — int — NOT NULL
  • alarm_count — int
  • pending_chat — int
  • pending_votes — int
  • group_id — int

accounts_user_contacts

  • id — bigint — 기본 키 — NOT NULL
  • contacts_count — int
  • invite_user_id_list — longtext
  • user_id — bigint

accounts_userquestionrecord

  • id — bigint — 기본 키 — NOT NULL
  • status — varchar(3) — NOT NULL
  • created_at — datetime
  • chosen_user_id — bigint — NOT NULL
  • question_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • question_piece_id — bigint — 외래 키 → polls_questionpiece.id — NOT NULL
  • has_read — tinyint(1) — NOT NULL
  • answer_status — varchar(1) — NOT NULL
  • answer_updated_at — datetime
  • report_count — int — NOT NULL
  • opened_times — int — NOT NULL

accounts_userwithdraw

  • id — bigint — 기본 키 — NOT NULL
  • reason — varchar(50) — NOT NULL
  • created_at — datetime

device_properties

  • id — int — 기본 키 — NOT NULL
  • device_id — varchar(255)
  • device_model — varchar(255)
  • device_vendor — varchar(255)

event_receipts

  • id — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • event_id — bigint — 외래 키 → events.id
  • user_id — bigint — 외래 키 → accounts_user.id — NOT NULL
  • plus_point — int — NOT NULL

events

  • id — bigint — 기본 키 — NOT NULL
  • title — varchar(200) — NOT NULL
  • plus_point — int — NOT NULL
  • event_type — varchar(5) — NOT NULL
  • is_expired — tinyint(1) — NOT NULL
  • created_at — datetime

hackle_events

  • event_id — varchar(255) — 기본 키 — NOT NULL
  • event_datetime — datetime
  • event_key — varchar(255)
  • session_id — varchar(255)
  • id — varchar(255)
  • item_name — varchar(255)
  • page_name — varchar(255)
  • friend_count — int
  • votes_count — int
  • heart_balance — int
  • question_id — int

hackle_properties

  • id — int — 기본 키 — NOT NULL
  • session_id — varchar(255)
  • user_id — varchar(255)
  • language — varchar(255)
  • osname — varchar(255)
  • osversion — varchar(255)
  • versionname — varchar(255)
  • device_id — varchar(255)

polls_question

  • id — bigint — 기본 키 — NOT NULL
  • question_text — varchar(200) — NOT NULL
  • created_at — datetime

polls_questionpiece

  • id — bigint — 기본 키 — NOT NULL
  • is_voted — tinyint(1) — NOT NULL
  • created_at — datetime
  • question_id — bigint — NOT NULL
  • is_skipped — tinyint(1) — NOT NULL

polls_questionreport

  • id — bigint — 기본 키 — NOT NULL
  • reason — longtext — NOT NULL
  • created_at — datetime
  • question_id — bigint — 외래 키 → polls_question.id — NOT NULL
  • user_id — bigint — 외래 키 → accounts_user.id — NOT NULL

polls_questionset

  • id — bigint — 기본 키 — NOT NULL
  • question_piece_id_list — longtext — NOT NULL
  • opening_time — datetime
  • status — varchar(1) — NOT NULL
  • created_at — datetime
  • user_id — bigint — NOT NULL

polls_usercandidate

  • id — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • question_piece_id — bigint — 외래 키 → polls_questionpiece.id — NOT NULL
  • user_id — bigint — NOT NULL

user_properties

  • user_id — varchar(255) — 기본 키 — NOT NULL
  • class — int
  • gender — varchar(10)
  • grade — int
  • school_id — int