Iot 플랫폼

테이블 (13)

Untitled4

    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

    sns (Untitled7)