슈퍼초천재

테이블 (19)

account

  • account_id — BIGINT(20) — 기본 키 — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50)
  • nick_name — VARCHAR(50)
  • phone_number — CHAR(50) — NOT NULL
  • email — VARCHAR(50)
  • country — CHAR(10) — NOT NULL
  • pet_care_level — INT(11)
  • is_first_signin — TINYINT(4)
  • reg_datetime (create_datetime) — DATETIME — NOT NULL

account_history

  • user_his_id (account_his_id) — BIGINT(20) — 기본 키 — NOT NULL
  • gender — INT(11)
  • age — INT(11)
  • location — VARCHAR(50)
  • signup_datetime (create_datetime) — DATETIME
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL

device

  • device_id — BIGINT(20) — 기본 키 — NOT NULL
  • device_tag (Field) — VARCHAR(50)
  • uid — VARCHAR(50)
  • device_name — VARCHAR(50)
  • reg_datetime (create_datetime) — DATETIME
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL

device_controller

  • controller_id — BIGINT(20) — 기본 키 — NOT NULL
  • temperature — INT(11) — NOT NULL
  • humidity — INT(11) — NOT NULL
  • device_type — VARCHAR(50) — NOT NULL
  • device_power — TINYINT(4) — NOT NULL
  • night — TINYINT(4) — NOT NULL
  • cleaning — TINYINT(4) — NOT NULL
  • cleaning_time — TINYINT(4) — NOT NULL
  • is_replace — TINYINT(4) — NOT NULL
  • purpose — VARCHAR(50) — NOT NULL
  • sand — VARCHAR(50) — NOT NULL
  • device_id — BIGINT(20) — 외래 키 → device.device_id — NOT NULL

device_history

  • device_his_id — BIGINT(20) — 기본 키 — NOT NULL
  • reg_datetime (create_datetime) — DATETIME — NOT NULL
  • device_id — BIGINT(20) — 외래 키 → device.device_id — NOT NULL
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL

device_pet_relat

  • deive_pet_id — BIGINT(20) — 기본 키 — NOT NULL
  • device_id (device_id2) — BIGINT(20) — 외래 키 → device.device_id — NOT NULL
  • pet_id (pet_id2) — BIGINT(20) — 외래 키 → pet.pet_id — NOT NULL

device_task_relate

  • relate_dt_id — BIGINT(20) — 기본 키 — NOT NULL
  • device_id — BIGINT(20) — 외래 키 → device.device_id — NOT NULL
  • task_todo_id — BIGINT(20) — 외래 키 → task_todo.task_todo_id — NOT NULL

diary

  • diary_id — BIGINT(20) — 기본 키 — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — VARCHAR(50) — NOT NULL
  • diary_date — DATETIME
  • create_datetime — DATETIME — NOT NULL
  • modify_datetime — DATETIME
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL
  • pet_id — BIGINT(20) — 외래 키 → pet.pet_id — NOT NULL

diary_img

  • diary_img_id — TINYINT(4) — 기본 키 — NOT NULL
  • img — VARCHAR(255)
  • create_datetime — DATETIME — NOT NULL
  • diary_id — BIGINT(20) — 외래 키 → diary.diary_id — NOT NULL

login_logs

  • login_log_id — BIGINT(20) — 기본 키 — NOT NULL
  • reg_datetime — DATETIME
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL

notification

  • Key (notification_id) — BIGINT(20) — 기본 키 — NOT NULL
  • registration_id — VARCHAR(255) — NOT NULL
  • os — VARCHAR(50) — NOT NULL
  • create_datetime — TIMESTAMP — NOT NULL
  • modify_datetime — TIMESTAMP — NOT NULL
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL

pet

  • pet_id — BIGINT(20) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • relation_tag_list — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(50) — NOT NULL
  • neutering — VARCHAR(50) — NOT NULL
  • weight — DECIMAL(10,0) — NOT NULL
  • birthday — DATE
  • reg_date (create_datetime) — DATETIME
  • Field (modify_datetime) — DATETIME
  • breed_id — BIGINT(20) — 외래 키 → pet_breed_type.breed_id — NOT NULL
  • avatar_id — BIGINT(20) — 외래 키 → pet_avatar_type.avatar_id — NOT NULL
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL

pet_avatar_type (pet_avatar)

  • avatar_id — BIGINT(20) — 기본 키 — NOT NULL
  • color — VARCHAR(50) — NOT NULL
  • pattern — VARCHAR(50) — NOT NULL
  • fur — VARCHAR(50) — NOT NULL
  • ear — VARCHAR(50) — NOT NULL
  • leg — VARCHAR(50) — NOT NULL
  • Field (create_datetime) — DATETIME

pet_breed_type (pet_breed)

  • breed_id — BIGINT(20) — 기본 키 — NOT NULL
  • country — VARCHAR(50) — NOT NULL
  • origin — VARCHAR(50) — NOT NULL
  • Field (create_datetime) — DATETIME

pet_history

  • pet_his_id — BIGINT(20) — 기본 키 — NOT NULL
  • reg_datetime (create_datetime) — DATETIME — NOT NULL
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL
  • pet_id — BIGINT(20) — 외래 키 → pet.pet_id — NOT NULL

pet_task_relate

  • relate_pt_id — BIGINT(20) — 기본 키 — NOT NULL
  • pet_id — BIGINT(20) — 외래 키 → pet.pet_id — NOT NULL
  • task_todo_id — BIGINT(20) — 외래 키 → task_todo.task_todo_id — NOT NULL

task_item

  • task_item_id — BIGINT(20) — 기본 키 — NOT NULL
  • task_name — VARCHAR(50) — NOT NULL
  • is_completed — TINYINT(4) — NOT NULL
  • planned_datetime — DATETIME — NOT NULL
  • completed_datetime — DATETIME — NOT NULL
  • author — BIGINT(20) — NOT NULL
  • is_committed — TINYINT(4)
  • tag_id — BIGINT(20)
  • pet_id — BIGINT(20) — 외래 키 → pet.pet_id — NOT NULL
  • device_id — BIGINT(20) — 외래 키 → device.device_id — NOT NULL
  • task_todo_id — BIGINT(20) — 외래 키 → task_todo.task_todo_id — NOT NULL

task_todo

  • task_todo_id — BIGINT(20) — 기본 키 — NOT NULL
  • date (task_date) — DATETIME — NOT NULL
  • author — VARCHAR(50) — NOT NULL
  • Field (etc)
  • res_date (create_datetime) — DATETIME — NOT NULL
  • Field (modify_datetime) — DATETIME
  • account_id — BIGINT(20) — 외래 키 → account.account_id — NOT NULL
  • task_type_id — BIGINT(20) — 외래 키 → task_type.task_type_id — NOT NULL
  • pet_id — BIGINT(20) — 외래 키 → pet.pet_id — NOT NULL

task_type

  • task_type_id — BIGINT(20) — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • type (main_type) — INT(11) — NOT NULL
  • sub_type — INT(11) — NOT NULL
  • is_repeat — VARCHAR(50) — NOT NULL
  • is_alert — VARCHAR(50) — NOT NULL
  • Field (repeat_unit)
  • repeat_period — VARCHAR(50) — NOT NULL
  • repeat_count — VARCHAR(50) — NOT NULL
  • alert_base_time — DATETIME
  • reminder_alert_time — DATETIME