Iot 플랫폼
테이블 (13)
account_site (회원 테이블)
- ascid (Key) — int — 기본 키 — NOT NULL
- type (Field) — int
- sns_type (Field28) — varchar
- id (Field2) — varchar
- name (Field4) — varchar
- celphone (Field6) — varchar
- password (Field7) — varchar
- zipcode (Field8) — varchar
- address1 (Field9) — varchar
- address2 (Field10) — varchar
- socialnumber (Field11) — char
- useragrement (Field12) — char
- useragrementdate (Field3) — date
- privacyagreement (Field13) — char
- privacyagreementdate (Field14) — date
- emailagreement (Field15) — char
- emailagreementdate (Field16) — date
- smsagreement (Field17) — char
- smsagreement (Field18) — date
- pushagreement (Field19) — char
- pushagreementdate (Field20) — date
- longintime (Field21) — datetime
- activation (Field22) — char
- unsubscribecomment (Field23) — varchar
- unsubscribedate (Field24) — date
- device_token (Field25) — varchar
- site_code (Field26) — varchar
- orgwritedate (Field27) — date
- toss_uuid (Field5)
banner (Untitled6)
- banner_id (Key) — int — 기본 키 — NOT NULL
- banner_type (Field) — char
- banner_sub_type (Field3) — varchar
- target_id (Field2) — varchar
- created_date (Field4) — date
- startdate (Field5) — date
- enddate (Field6) — date
- Field7
car_information (차량 정보)
- car_id (Key) — int — 기본 키 — NOT NULL
- ascid (Key2) — int — 외래 키 → account_site.ascid — NOT NULL
- car_number (Field6) — varchar
- cartype (Field) — varchar
- year_of_manufacture (Field2) — int
- car_color (Field3) — varchar
- engine_displacement (Field4) — int
- date_registration (Field5) — date
ccsp (Untitled3)
- ccsp_id (Key) — int — 기본 키 — NOT NULL
- Field
faq_category (Untitled)
- faq_id (Key) — int — 기본 키 — NOT NULL
- faq_type (Field) — varchar
faq_detail (Untitled2)
- faq_detail_id (Key2) — int — 기본 키 — NOT NULL
- faq_id (Key) — int — 외래 키 → faq_category.faq_id — NOT NULL
- faq_title (Field) — varchar
- faq_answer (Field2) — varchar
- faq_date (Field3) — date
iot_device (Iot 기기 정보)
- iot_device_id (Key) — int — 기본 키 — NOT NULL
- car_id (Key2) — int — 외래 키 → car_information.car_id — NOT NULL
- device_type (Field) — varchar
- device_uuid (Field2) — varchar
- device_name (Field3) — varchar
post (게시물)
- post_id (Key) — int — 기본 키 — NOT NULL
- ascid (Key2) — int — 외래 키 → account_site.ascid — NOT NULL
- post_write_name (Field6) — varchar
- post_type (Field) — varchar
- post_title (Field2) — varchar
- post_content (Field4) — varchar
- post_img (Field5) — varchar
- post_write_date (Field7) — date
- post_activation (Field8) — int
post_comment (게시물 댓글)
- post_comment_id (Key) — int — 기본 키 — NOT NULL
- post_id (Key2) — int — 외래 키 → post.post_id — NOT NULL
- ascid (Key3) — int — 외래 키 → account_site.ascid — NOT NULL
- comment_content (Field) — varchar
- comment_date (Field2) — varchar
- comment_activation (Field3) — int
product(TBD) (Untitled5)
- pid (Key) — int — 기본 키 — NOT NULL
- Field
report (신고)
- report_id (Key) — int — 기본 키 — NOT NULL
- reporter_id (Field6) — int
- reportee_id (Field7) — int
- report_target_type (Field) — int
- report_post_id (Field2) — int
- report_post_comment_id (Field3) — int
- report_content (Field5) — varchar
- report_date (Field4) — date