건_0.1ver
테이블 (24)
AddCatStuff
- user_id — VARCHAR(10) — 외래 키 → Cat.user_id — NOT NULL
- cat_id — INT — 외래 키 → Cat.Cat_id — NOT NULL
- stuff_type_id — INT — 외래 키 → CatStuffTypeList.CatStuffTypeList_id — NOT NULL
- puchase_date (purchase_date) — DATE — NOT NULL
- add_date — DATE — NOT NULL
- due_date — DATE
- location — VARCHAR(30)
- amount — INT
- price — INT
- purchase_link — VARCHAR(100)
AddFoodItem
- user_id — VARCHAR(10) — 외래 키 → User.user_id — NOT NULL
- food_type_id — INT — 외래 키 → FoodItemTypeList.FoodItemTypeList_id — NOT NULL
- puchase_date (purchase_date) — DATE
- add_date — DATE
- location — VARCHAR(30)
- amount — INT
AddStuff
- user_id — VARCHAR(10) — 외래 키 → User.user_id — NOT NULL — PK
- stuff_type_id — INT — 외래 키 → StuffTypeList.StuffTypeList_id — NOT NULL
- stuff_price — INT
- amount — INT — NOT NULL
- purchase_link — VARCHAR(100)
AddTask
- user_id — VARCHAR(10) — 외래 키 → User.user_id — NOT NULL — PK
- task_type_id — INT — 외래 키 → TaskTypeList.TaskTypeList_id — NOT NULL — PK
- add_date — DATE — NOT NULL
- due_date — DATE — NOT NULL
- location — VARCHAR(30)
- comment — VARCHAR(100)
Bill
- Bill_id (id) — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → User.user_id — NOT NULL
- due_date — DATE — NOT NULL
- cost — INT — NOT NULL
- type — VARCHAR(10) — NOT NULL
BillAlarm
- bill_id — INT — 외래 키 → Bill.Bill_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → Bill.user_id — NOT NULL
- alarm_on_off — BOOL — NOT NULL
Cat
- Cat_id (id) — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → User.user_id — NOT NULL
- cat_name — VARCHAR(10) — NOT NULL
- cat_birth — DATE
- cat_type — VARCHAR(10)
- cat_comment — VARCHAR(20)
CatDiary
- CatDiary_id (id) — INT — 기본 키 — NOT NULL
- cat_id — INT — 외래 키 → Cat.Cat_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → Cat.user_id — NOT NULL
- diary_title — VARCHAR(20) — NOT NULL
- diary_date — DATE — NOT NULL
- diary_content — VARCHAR(1000)
- diary_condition — VARCHAR(30)
- diary_food_amount — VARCHAR(100)
- diary_water_amount — VARCHAR(100)
CatMedicalRecord
- CatMedicalRecord_id (id) — INT — 기본 키 — NOT NULL
- cat_id — INT — 외래 키 → Cat.Cat_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → Cat.user_id — NOT NULL
- hospital_name — VARCHAR(20)
- record_date — DATE — NOT NULL
- treatment_details — VARCHAR(100)
CatStuffAlarm
- cat_stuff_id — INT — 외래 키 → MyCatStuff.MyCatStuff_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → MyCatStuff.user_id — NOT NULL
- cat_id — INT — 외래 키 → MyCatStuff.cat_id — NOT NULL
- stuff_type_id — INT — 외래 키 → MyCatStuff.stuff_type_id — NOT NULL
- alarm_on_off — BOOL — NOT NULL
CatStuffTypeList (CatStuffList)
- CatStuffTypeList_id (id) — INT — 기본 키 — NOT NULL
- stuff_name — VARCHAR(10) — NOT NULL
- stuff_brand — VARCHAR(10)
FoodItemAlarm
- my_food_item_id — INT — 외래 키 → MyFoodItem.MyFoodItem_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → MyFoodItem.user_id — NOT NULL
- food_type_id — INT — 외래 키 → MyFoodItem.food_type_id — NOT NULL
- alarm_on_off — BOOL — NOT NULL
FoodItemTypeList
- FoodItemTypeList_id (id) — INT — 기본 키 — NOT NULL
- food_name — VARCHAR(20) — NOT NULL
- typical_expiration_date — INT — NOT NULL
- storage_tip — VARCHAR(30)
MyCatStuff (CatStuff)
- MyCatStuff_id (id) — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → AddCatStuff.user_id — NOT NULL
- cat_id — INT — 외래 키 → AddCatStuff.cat_id — NOT NULL
- stuff_type_id — INT — 외래 키 → AddCatStuff.stuff_type_id — NOT NULL
- remain_amount — INT
MyFoodItem
- MyFoodItem_id (id) — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → AddFoodItem.user_id — NOT NULL
- food_type_id — INT — 외래 키 → AddFoodItem.food_type_id — NOT NULL
MyStuff
- MyStuff_id (id) — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → AddStuff.user_id — NOT NULL — PK
- stuff_type_id — INT — 외래 키 → AddStuff.stuff_type_id — NOT NULL
- remain_amount — INT
MyTask
- MyTask_id (id) — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → AddTask.user_id — NOT NULL — PK
- task_type_id — INT — 외래 키 → AddTask.task_type_id — NOT NULL — PK
Pay
- bill_id — INT — 외래 키 → Bill.Bill_id — NOT NULL
- user_id (user_id2) — VARCHAR(10) — 외래 키 → Bill.user_id — NOT NULL
- payment_type_id — INT — 외래 키 → PaymentInfo.Paymentlnfo_id — NOT NULL
- pay_date — DATE — NOT NULL
PaymentInfo
- Paymentlnfo_id (id) — INT — 기본 키 — NOT NULL
- payment_type — VARCHAR(10) — NOT NULL
- card_company — VARCHAR(20) — NOT NULL
StuffAlarm
- my_stuff_id — INT — 외래 키 → MyStuff.MyStuff_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → MyStuff.user_id — NOT NULL — PK
- stuff_type_id — INT — 외래 키 → MyStuff.stuff_type_id — NOT NULL
- alarm_on_off — BOOL — NOT NULL
StuffTypeList
- StuffTypeList_id (id) — INT — 기본 키 — NOT NULL
- stuff_name — VARCHAR(30) — NOT NULL
- stuff_brand — VARCHAR(30) — NOT NULL
TaskAlarm
- my_task_id — INT — 외래 키 → MyTask.MyTask_id — NOT NULL
- user_id — VARCHAR(10) — 외래 키 → MyTask.user_id — NOT NULL — PK
- task_type_id — INT — 외래 키 → MyTask.task_type_id — NOT NULL — PK
- alarm_on_off — BOOL — NOT NULL
TaskTypeList
- TaskTypeList_id (task_id) — INT — 기본 키 — NOT NULL
- task_name — VARCHAR(30) — NOT NULL
- task_info — VARCHAR(50) — NOT NULL
User
- user_id — VARCHAR(10) — 기본 키 — NOT NULL
- password — VARCHAR(20) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- phone — INT — NOT NULL
- residence_info — VARCHAR(100) — NOT NULL