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