NYAM
Tables (5)
Board (식단)
- id — INT — Primary key — NOT NULL
- food_name — VARCHAR(10)
- calorie — INT
- carbs — INT
- protein — INT
- reg_date — TIMESTAMP
Disease (질병)
- disease_id — INT — Primary key — NOT NULL
- disease_name — VARCHAR(30)
Foods (음식)
- food_id — INT — Primary key — NOT NULL
- food_name — VARCHAR(10)
- calorie — INT
- carbs — INT
- protein — INT
User (회원)
- userid — INT — Primary key — NOT NULL
- pw — VARCHAR(20)
- name — VARCHAR(20)
- age — INT
- height — INT
- weight — INT
- abled — BOOLEAN
User_disease (회원의 질병)
- userid — INT — Foreign key → User.userid — NOT NULL
- disease_id — INT — Foreign key → Disease.disease_id — NOT NULL