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