Whedit
Tables (5)
electronics
- electronics_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → user.user_id — NOT NULL
- name — varchar(50)
- purchase_date — datetime
- life_expectancy — int
- breakdown — enum('normal','breakdown reack')
- memo — varchar(1000)
- use_status — tinyint
food
- food_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → user.user_id — NOT NULL
- name — varchar(50)
- purchase_date — datetime
- expiration_date — datetime
- memo — varchar(1000)
- use_status — tinyint
medicine
- medicine_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → user.user_id — NOT NULL
- name — varchar(255)
- medication_period — varchar(100)
- prescription — tinyint
- purchase_date — datetime
- memo — varchar(1000)
necessaries
- necessaries_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → user.user_id — NOT NULL
- name — varchar(50)
- purchase_date — datetime
- life_expectancy — int
- memo — varchar(1000)
- use_status — tinyint
user
- user_id — long — Primary key — NOT NULL
- id — varchar(50)
- password — varchar(255)
- nickname — varchar(10)
- created_at — datetime
- updated_at — datetime