슈퍼초천재
테이블 (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