spoonsors
Tables (8)
bmember
- bMember_id — VARCHAR(100) — Primary key — NOT NULL
- bMember_pwd — VARCHAR(100) — NOT NULL
- bMember_nickname — VARCHAR(100) — NOT NULL
- bMember_name — VARCHAR(100) — NOT NULL
- bMember_birth — DATE — NOT NULL
- bMember_phoneNumber — VARCHAR(100) — NOT NULL
- can_post — INT — NOT NULL
- bMember_address — VARCHAR(100) — NOT NULL
- bMember_certificate — TEXT — NOT NULL
- role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
- token — VARCHAR(255)
- is_verified — TINYINT — NOT NULL
- profile_path — VARCHAR(255) — NOT NULL
fridge
- fridge_id — BIGINT — Primary key — NOT NULL
- bMember_id — VARCHAR(100) — Foreign key → bmember.bMember_id — NOT NULL
- fridge_item_name — VARCHAR(100) — NOT NULL
- fridge_item_img — TEXT
- is_frized — TINYINT — NOT NULL
- expiration_date — DATE
- ingredients_id — BIGINT — Foreign key → ingredients.ingredients_id
ingredients
- ingredients_id — BIGINT — Primary key — NOT NULL
- ingredients_name — VARCHAR(100) — NOT NULL
- product_name — VARCHAR(100)
- ingredients_image — TEXT
- price — INT — NOT NULL
meal_planner
- mealPlanner_id — BIGINT — Primary key — NOT NULL
- menu_name1 — VARCHAR(255) — NOT NULL
- menu_img1 — TEXT — NOT NULL
- menu_name2 — VARCHAR(255)
- menu_img2 — TEXT
- menu_name3 — VARCHAR(255)
- menu_img3 — TEXT
- menu_name4 — VARCHAR(255)
- menu_img4 — TEXT
- mealPlanner_name — VARCHAR(100) — NOT NULL
- kcal — FLOAT
- carbohydrate — FLOAT
- protein — FLOAT
- fat — FLOAT
- na — FLOAT
- level — VARCHAR(10)
post
- post_id — BIGINT — Primary key — NOT NULL
- writer_id — VARCHAR(100) — Foreign key → bmember.bMember_id — NOT NULL
- post_title — VARCHAR(100)
- post_txt — VARCHAR(400)
- post_state — TINYINT
- has_review — TINYINT — NOT NULL
- post_date — DATETIME — NOT NULL
- remain_spon — INT — NOT NULL
- menu_img — TEXT
- menu_name — VARCHAR(255)
review
- review_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- review_img — TEXT
- review_txt — VARCHAR(400)
- review_date — DATETIME — NOT NULL
smember
- sMember_id — VARCHAR(100) — Primary key — NOT NULL
- sMember_pwd — VARCHAR(100) — NOT NULL
- sMember_nickname — VARCHAR(100) — NOT NULL
- sMember_name — VARCHAR(100) — NOT NULL
- sMember_phoneNumber — VARCHAR(100) — NOT NULL
- role — ENUM('ROLE_USER', 'ROLE_ADMIN')
- token — VARCHAR(255)
- profile_path — VARCHAR(255) — NOT NULL
spon
- spon_id — BIGINT — Primary key — NOT NULL
- ingredients_id (ingredients_id2) — BIGINT — Foreign key → ingredients.ingredients_id — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- spon_date — DATETIME
- is_sponed — TINYINT — NOT NULL
- tid — VARCHAR(255)
- sMember_id — VARCHAR(100) — Foreign key → smember.sMember_id