advanced_project
Tables (24)
accounts_attendance (출석 테이블)
- id (Field) — bigint — Primary key — NOT NULL
- attendance_date_list (Field2) — longtext — NOT NULL
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_blockrecord (차단 기록 테이블)
- id (Field) — bigint — Primary key — NOT NULL
- reason (Field2) — varchar(50) — NOT NULL
- created)at (Field3) — datetime
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
- block_user_id (유저 id2) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_failpaymenthistory (상품 구매 실패 기록 테이블)
- id (Field) — bigint — Primary key — NOT NULL
- productId (Field2) — varchar(100)
- phone_type (Field3) — varchar(1) — NOT NULL
- created_at (Field4) — datetime
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_friendrequest (친구 요청 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- status (Field) — varchar(1) — NOT NULL
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
- receive_user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
- send_user_id (유저 id2) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_group (학급 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- grade (Field) — int — NOT NULL
- class_num (Field2) — int — NOT NULL
- school_id (Key2) — bigint — Foreign key → accounts_school.id — NOT NULL
accounts_nearbyschool (가까운 학교를 기록해두기 위한 관계형 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- distance (Field) — double — NOT NULL
- nearby_school_id (Key2) — bigint — Foreign key → accounts_school.id — NOT NULL
- school_id (Key3) — bigint — Foreign key → accounts_school.id — NOT NULL
accounts_paymenthistory (구매 기록 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- productId (Field) — carchar(100) — NOT NULL
- phone_type (Field2) — varchar(1) — NOT NULL
- created_at (Field3) — datetime
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_pointhistory (포인트 기록 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- delta_point (Field) — int — NOT NULL
- created_at (Field2) — datetime
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_school (학교 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- address (Field) — varchar(100) — NOT NULL
- student_count (Field2) — int — NOT NULL
- school_type (Field3) — varchar(1) — NOT NULL
accounts_user (유저 테이블)
- id (유저 id) — bigint — Primary key — NOT NULL
- is_superuser (Field) — tinyint(1) — NOT NULL
- is_staff (Field2) — tinyint(1) — NOT NULL
- gender (Field3) — varchar(1)
- point (Field4) — int — NOT NULL
- friend_id_list (Field5) — longtext
- is_push_on (Field6) — tinyint(1) — NOT NULL
- created_at (Field7) — datetime(6) — NOT NULL
- block_user_id_list (Field8) — longtext
- hide_user_id_list (Field9) — longtext
- ban_status (Field10) — varchar(2) — NOT NULL
- report_count (Field11) — int — NOT NULL
- alarm_count (i) — int
- panding_chat (Field12) — int
- pending_votes (Field13) — int
- group_id (Key2) — int — Foreign key → accounts_group.id
accounts_user_contacts (유저 컨택 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- contacts_count (Field) — int
- invite_user_id_list (유저 id) — longtext — Foreign key → accounts_user.id — NOT NULL
- user_id (유저 id2) — bigint — Foreign key → accounts_user.id — NOT NULL
accounts_user_questionrecord (투표 기록 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- status (Field) — varchar(3) — NOT NULL
- created_at (Field2) — datetime
- chosen_user_id (Field3) — bigint — NOT NULL
- question_id (Field4) — bigint — NOT NULL
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
- question_piece_id (Key2) — bigint — Foreign key → polls_questionpiece.id — NOT NULL
- has_read (Field6) — tinyint(1) — NOT NULL
- answer_status (Field7) — varchar(1) — NOT NULL
- answer_updated_at (Field8) — datetime
- report_count (Field9) — int — NOT NULL
- opened_times (Field10) — int — NOT NULL
accounts_userwithdraw (탈퇴 기록 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- reason (Field) — varchar(50) — NOT NULL
- created_at (Field2) — datetime
device_properties (CopyOfCopyOfUntitled2)
- id (Key) — int — Primary key — NOT NULL
- device_id (Field) — varchar(255)
- device_model (Field2) — varchar(255)
- device_vendor (Field3) — varchar(255)
event_receipts (포인트 이벤트 참여 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime
- event_id (Key2) — bigint — Foreign key → events.id — NOT NULL
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
- plus_point (Field3) — int — NOT NULL
events (포인트 이벤트 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- title (Field) — varchar(200) — NOT NULL
- plus_point (Field2) — int — NOT NULL
- event_type (Field3) — varchar(5) — NOT NULL
- is_expired (Field4) — tinyint(1) — NOT NULL
- created_at (Field5) — datetime
hackle.hackle_events (CopyOfUntitled2)
- event_id (Key) — varchar(255) — Primary key — NOT NULL
- event_datetime (Field) — datetime
- event_key (Field2) — varchar(255)
- session_id (Field3) — varchar(255)
- id (Field4) — varchar(255)
- item_name (Field5) — varchar(255)
- page_name (Field6) — varchar(255)
- friend_count (Field7) — int
- votes_count (Field8) — int
- heart_balance (Field9) — int
- question_id (Field10) — int
hackle.hackle_properties (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- session_id (Field) — varchar(255)
- user_id (Field2) — varchar(255)
- language (Field3) — varchar(255)
- osname (Field4) — varchar(255)
- osversion (Field5) — varchar(255)
- versionname (Field6) — varchar(255)
- device_id (Field7) — varchar(255)
hackle.user_properties (Untitled)
- user_id (Key) — varchar(255) — Primary key — NOT NULL
- class (Field) — int
- gender (Field2) — varchar(10)
- grade (Field3) — int
- school_id (Field4) — int
polls_question (질문 데이터 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- question_text (varchar) — varchar(200) — NOT NULL
- created_at (Field) — datetime
polls_questionpiece (질문 조각)
- id (Key) — bigint — Primary key — NOT NULL
- is_voted (Field) — tinyint(1) — NOT NULL
- created_at (Field2) — datetime
- question_id (Key2) — bigint — Foreign key → polls_question.id — NOT NULL
- is_skipped (Field3) — tinyint(1) — NOT NULL
polls_questionreport (질문에 대한 신고기록 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- reason (Field) — longtext — NOT NULL
- created_at (Field2) — datetime
- question_id (Key2) — bigint — Foreign key → polls_question.id — NOT NULL
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
polls_questionset (질문 세트 데이블)
- id (Key) — bigint — Primary key — NOT NULL
- question_piece_id_list (Key2) — longtext — Foreign key → polls_questionpiece.id — NOT NULL
- opening_time (Field2) — datetime
- status (Field) — varchar(1) — NOT NULL
- created_at (Field3) — datetime
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL
polls_usercadidate (질문 조각에 등장하는 유저들 테이블)
- id (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime
- question_piece_id (Key2) — bigint — Foreign key → polls_questionpiece.id — NOT NULL
- user_id (유저 id) — bigint — Foreign key → accounts_user.id — NOT NULL