curumamori

테이블 (9)

attachment(첨부 파일) (Untitled8)

  • attachment_id (Key2) — NOT NULL — 기본 키 — NOT NULL
  • question_id (Key) — NOT NULL — 외래 키 → question(질문 게시판).question_id — NOT NULL
  • file_name (Field) — NOT NULL
  • size (Field2) — NOT NULL
  • mime (Field3) — NOT NULL

comment(댓글) (Untitled7)

  • comment_id (Key2) — NOT NULL — 기본 키 — NOT NULL
  • question_id (Key) — NOT NULL — 외래 키 → question(질문 게시판).question_id — NOT NULL
  • user_id (Field2) — NOT NULL — 외래 키 → question(질문 게시판).user_id
  • content (Field) — NOT NULL

drive(운전) (Untitled2)

  • drive_id (Field6) — NOT NULL — 기본 키
  • user_id (Field2) — NOT NULL — 외래 키 → user(유저).id
  • driving_time (Field) — NOT NULL
  • date (Field3) — NOT NULL
  • start_time (Field4) — NOT NULL
  • end_timed (Field5) — NOT NULL

drive_safety(운전 안전점수) (Untitled3)

  • drive_safety_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • drive_id (Field22) — NOT NULL — 외래 키 → drive(운전).user_id
  • sudden_stop_count (Field) — NOT NULL
  • sudden_acceleration_count (Field2) — NOT NULL
  • drowsy_driving_count (Field3) — NOT NULL
  • sleep_count (Field4) — NOT NULL

insurance(보험사) (Untitled9)

  • insurance_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Field2) — NOT NULL — 외래 키 → user(유저).id
  • insurance_name (Field) — NOT NULL
  • insurance_phone (Field3) — NOT NULL
  • subscription_date (Field4) — NOT NULL
  • expiration_date (Field5) — NOT NULL

medical_info(의료정보) (Untitled5)

  • medical_id (Field) — NOT NULL — 기본 키
  • user_id (Field2) — NOT NULL — 외래 키 → user(유저).id — NOT NULL
  • sickness (Field5) — NOT NULL
  • guardian_phone (Field3) — NULL
  • symptom (Field6) — NULL
  • medicine (Field7) — NULL
  • hospital (Field8) — NULL
  • hospital_phone (Field9) — NULL
  • nursing_home (Field10) — NULL
  • rursing_home_phone (Field11) — NULL

product(제품) (Untitled4)

  • product_id (Field4) — NOT NULL — 기본 키
  • user_id (Field6) — NOT NULL — 외래 키 → user(유저).id
  • product_name (Field3) — NOT NULL
  • product_key (Field) — NOT NULL
  • date_buy (Field2) — NOT NULL

question(질문 게시판) (Untitled6)

  • question_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Field2) — NOT NULL — 외래 키 → user(유저).id
  • title (Field) — NOT NULL
  • content (Field3) — NOT NULL

user(유저) (Untitled)

  • id (Field) — NOT NULL — 기본 키
  • email (Field2) — NOT NULL
  • password (Field3) — NOT NULL
  • name (Field4) — NOT NULL
  • age (Field5) — NOT NULL
  • gender (Field6) — NOT NULL
  • phone (Field7) — NOT NULL
  • created_at (Field8) — NOT NULL
  • confirm_code (Field9) — NOT NULL
  • check_disease (Field10) — NOT NULL