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