Tosit

Tables (10)

cocktail_custom (사용자 칵테일)

  • drink_id (primary) — bigint(20) — Primary key — NOT NULL
  • drink_name (Field) — varchar(45)
  • drink_explain (Field2) — varchar(255)
  • drink_recipe (Field3) — varchar(255)
  • drink_create_date (Field4) — timestamp
  • drink_create_date (Field5) — timestamp
  • follow_id (primary3) — bigint(20) — Foreign key → user_follow.follow_id — NOT NULL
  • like_id (primary2) — bigint(20) — Foreign key → user_likes.like_id — NOT NULL
  • Field6

cocktail_custom_ingredient (칵테일 레시피)

  • pk_cocktail_custom_ingredient (primary) — bigint(20) — Primary key — NOT NULL
  • quantity (Field3)
  • drink_id (primary2) — bigint(20) — Foreign key → cocktail_custom.drink_id — NOT NULL
  • ingredient_id (Key) — bigint(20) — Foreign key → ingredient.ingredient_id — NOT NULL

email_auths (이메일 인증)

  • email_auth_id (primary) — bigint(20) — Primary key — NOT NULL
  • user_id (primary2) — bigint(20) — Foreign key → users.user_id — NOT NULL
  • secured_key (Field) — varchar(255)
  • date_expired (Field2) — timestamp
  • email (Field3) — varchar(50)

images (이미지)

  • image_id (primary) — bigint(20) — Primary key — NOT NULL
  • user_id (primary2) — bigint(20) — Foreign key → users.user_id — NOT NULL
  • image_path (Field) — varchar(255)
  • Field6 (Field1) — varchar(50)
  • image_type (Field2) — varchar(50)
  • image_size (Field3) — bigint(20)
  • create_date (Field4) — timestamp
  • modify_date (Field5) — timestamp
  • image_use (Field6) — varchar(10) — NOT NULL

ingredient (칵테일 재료)

  • ingredient_id (Key) — bigint(20) — Primary key — NOT NULL
  • ingredient_name (Field) — varchar(50)
  • unit (Field2) — varchar(20)

tokens (토큰)

  • token_id (primary) — bigint(20) — Primary key — NOT NULL
  • user_id (primary2) — bigint(20) — Foreign key → users.user_id — NOT NULL
  • access_token (Field) — varchar(255)
  • refresh_token (Field2) — varchar(255)
  • create_date (Field3) — timestamp
  • modify_date (Field4) — timestamp
  • grant_type (Field5) — varchar(10)

user_follow (팔로우)

  • follow_id (primary) — bigint(20) — Primary key — NOT NULL
  • user_id (primary2) — bigint(20) — Foreign key → users.user_id — NOT NULL
  • follower (Field) — varchar(20)
  • followee (Field2) — varchar(20)

user_likes (좋아요)

  • like_id (primary) — bigint(20) — Primary key — NOT NULL
  • user_id (primary3) — bigint(20) — Foreign key → users.user_id — NOT NULL
  • cocktail_id (Field2) — int
  • cocktail_custom_id (Field3) — int

user_sns (유저 sns)

  • user_sns_id (primary) — bigint(20) — Primary key — NOT NULL
  • user_id (primary2) — bigint(20) — Foreign key → users.user_id — NOT NULL
  • sns_id (Field) — bigint(20)
  • sns_type (Field2) — enum
  • create_date (Field4) — timestamp
  • modify_date (Field5) — timestamp
  • thunail_image_url (Field3) — varchar(255)

users (회원)

  • user_id (primary) — bigint(20) — Primary key — NOT NULL
  • email (Field) — varchar(50)
  • password (Field2) — varchar(15)
  • create_date (Field3) — timestamp
  • modify_date (Field4) — timestamp
  • authority (Field5) — enum
  • image_url (Field7) — varchar(255)
  • visit_number (Field6) — int
  • user_rank (Field8) — varchar(10)
  • drink_id (primary2) — bigint(20) — Foreign key → cocktail_custom.drink_id — NOT NULL