건_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