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