COCKTIAL

Tables (9)

COCKTIAL (Untitled)

  • COCKTIAL_ID (Key) — BIGINT(AUTO INCREMENT) — Primary key — NOT NULL
  • COCKTAIL_NAME (Field2) — VARCHAR(255)
  • COCKTAIL_CATEGORY (Field) — VARCHAR(255)
  • COCKTAIL_ALCOHOLIC (Field3) — VARCHAR(255)
  • COCKTAIL_GLASS (Field4) — VARCHAR(255)
  • COCKTAIL_INSTRUCTIONS (Field5) — VARCHAR(2000)
  • COCKTAIL_IMAGE_URL (Field6) — VARCHAR(255)
  • CCL (Field7) — VARCHAR(255)
  • RC_WEATHER (Field8) — VARCHAR(255)
  • COCKTAIL_INGREDIENT1 (Field9) — VARCHAR(255)
  • COCKTAIL_INGREDIENT2 (Field10) — VARCHAR(255)
  • COCKTAIL_INGREDIENT3 (Field11) — VARCHAR(255)
  • COCKTAIL_INGREDIENT4 (Field12) — VARCHAR(255)
  • COCKTAIL_INGREDIENT5 (Field13) — VARCHAR(255)
  • COCKTAIL_INGREDIENT6 (Field14) — VARCHAR(255)
  • COCKTAIL_INGREDIENT7 (Field15) — VARCHAR(255)
  • COCKTAIL_INGREDIENT8 (Field16) — VARCHAR(255)
  • COCKTAIL_INGREDIENT9 (Field17) — VARCHAR(255)
  • COCKTAIL_INGREDIENT10 (Field18) — VARCHAR(255)
  • COCKTAIL_INGREDIENT11 (Field19) — VARCHAR(255)
  • COCKTAIL_INGREDIENT12 (Field20) — VARCHAR(255)
  • COCKTAIL_INGREDIENT13 (Field21) — VARCHAR(255)
  • COCKTAIL_INGREDIENT14 (Field22) — VARCHAR(255)
  • COCKTAIL_INGREDIENT15 (Field23) — VARCHAR(255)
  • COCKTAIL_MEASURE1 (Field24) — VARCHAR(255)
  • COCKTAIL_MEASURE2 (Field25) — VARCHAR(255)
  • COCKTAIL_MEASURE3 (Field26) — VARCHAR(255)
  • COCKTAIL_MEASURE4 (Field27) — VARCHAR(255)
  • COCKTAIL_MEASURE5 (Field28) — VARCHAR(255)
  • COCKTAIL_MEASURE6 (Field29) — VARCHAR(255)
  • COCKTAIL_MEASURE7 (Field30) — VARCHAR(255)
  • COCKTAIL_MEASURE8 (Field31) — VARCHAR(255)
  • COCKTAIL_MEASURE9 (Field32) — VARCHAR(255)
  • COCKTAIL_MEASURE10 (Field33) — VARCHAR(255)
  • COCKTAIL_MEASURE11 (Field34) — VARCHAR(255)
  • COCKTAIL_MEASURE12 (Field35) — VARCHAR(255)
  • COCKTAIL_MEASURE13 (Field36) — VARCHAR(255)
  • COCKTAIL_MEASURE14 (Field37) — VARCHAR(255)
  • COCKTAIL_MEASURE15 (Field38) — VARCHAR(255)
  • RC_TASTE (Field39) — VARCHAR(255)

CUSTOM_COCKTAIL (Untitled2)

  • CUSTOM_ID (Key) — BIGINT(AUTO INCREMENT) — Primary key — NOT NULL
  • CUSTOM_NM (Field) — VARCHAR(255)
  • CUSTOM_RCP (Field2) — VARCHAR(255)
  • CUSTOM_IMAGE_URL (Field3) — VARCHAR(255)
  • CUSTOM_VIEW (Field34) — INT
  • CUSTOM_ALCOHOLIC (Field35) — VARCHAR(255)
  • CUSTOM__GLASS (Field36) — VARCHAR(255)
  • CUSTOM_INGREDIENT1 (Field4) — VARCHAR(255)
  • CUSTOM_INGREDIENT2 (Field5) — VARCHAR(255)
  • CUSTOM_INGREDIENT3 (Field6) — VARCHAR(255)
  • CUSTOM_INGREDIENT4 (Field7) — VARCHAR(255)
  • CUSTOM_INGREDIENT5 (Field8) — VARCHAR(255)
  • CUSTOM_INGREDIENT6 (Field9) — VARCHAR(255)
  • CUSTOM_INGREDIENT7 (Field10) — VARCHAR(255)
  • CUSTOM_INGREDIENT8 (Field11) — VARCHAR(255)
  • CUSTOM_INGREDIENT9 (Field12) — VARCHAR(255)
  • CUSTOM_INGREDIENT10 (Field13) — VARCHAR(255)
  • CUSTOM_INGREDIENT11 (Field14) — VARCHAR(255)
  • CUSTOM_INGREDIENT12 (Field15) — VARCHAR(255)
  • CUSTOM_INGREDIENT13 (Field16) — VARCHAR(255)
  • CUSTOM_INGREDIENT14 (Field17) — VARCHAR(255)
  • CUSTOM_INGREDIENT15 (Field18) — VARCHAR(255)
  • CUSTOM_MEASURE1 (Field19) — VARCHAR(255)
  • CUSTOM_MEASURE2 (Field20) — VARCHAR(255)
  • CUSTOM_MEASURE3 (Field21) — VARCHAR(255)
  • CUSTOM_MEASURE4 (Field22) — VARCHAR(255)
  • CUSTOM_MEASURE5 (Field23) — VARCHAR(255)
  • CUSTOM_MEASURE6 (Field24) — VARCHAR(255)
  • CUSTOM_MEASURE7 (Field25) — VARCHAR(255)
  • CUSTOM_MEASURE8 (Field26) — VARCHAR(255)
  • CUSTOM_MEASURE9 (Field27) — VARCHAR(255)
  • CUSTOM_MEASURE10 (Field28) — VARCHAR(255)
  • CUSTOM_MEASURE11 (Field29) — VARCHAR(255)
  • CUSTOM_MEASURE12 (Field30) — VARCHAR(255)
  • CUSTOM_MEASURE13 (Field31) — VARCHAR(255)
  • CUSTOM_MEASURE14 (Field32) — VARCHAR(255)
  • CUSTOM_MEASURE15 (Field33) — VARCHAR(255)
  • MEMBER_ID (Key2) — BIGINT — Foreign key → MEMBER.MEMBER_ID — NOT NULL

CUSTOM_COCKTAIL_RECOMMENDATION (Untitled4)

  • RECOMMENDATION_ID (Key) — BIGINT — Primary key — NOT NULL
  • CUSTOM_ID (Key2) — BIGINT(AUTO INCREMENT) — Foreign key → CUSTOM_COCKTAIL.CUSTOM_ID — NOT NULL
  • MEMBER_ID (Key3) — BIGINT — Foreign key → MEMBER.MEMBER_ID — NOT NULL

JWT_TOKEN (Untitled6)

  • TOKEN_ID (Key) — BIGINT — Primary key — NOT NULL
  • MEMBER_ID (Key2) — BIGINT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • GRANT_TYPE (Field) — VARCHAR(255)
  • ACCESSTOKEN (Field2) — VARCHAR(255)
  • REFRESHTOKEN (Field3) — VARCHAR(255)
  • EXPIRE_IN (Field4) — DATETIME

MEMBER (Untitled5)

  • MEMBER_ID (Key) — BIGINT — Primary key — NOT NULL
  • MEMBER_NM (Field) — VARCHAR(20)
  • EMAIL (Field2) — VARCHAR(50)
  • MEMBER_PW (Field3) — VARCHAR(150)
  • MEMBER_YMD (Field4) — VARCHAR(8)
  • GENDER (Field5) — VARCHAR(1)
  • MEMBER_PH (Field6) — VARCHAR(11)
  • MEMBER_ROLE (Field7) — VARCHAR(5)
  • LOGIN_TYPE (Field8) — ENUM("N","Y")
  • TOKEN_ID (Field9) — VARCHAR(100)
  • MER_TASTE (Field10) — VARCHAR(255)
  • WITHDRAWAL_DATE (Field11) — DATETIME(6)
  • MEMBER_IMG_U (Field12) — VARCHAR(255)
  • MEMBER_INTRODUCTION (Field13) — VARCHAR(255)
  • QUESTION_CD (Key2) — VARCHAR(255) — Foreign key → RECORD.QUESTION_CD — NOT NULL

RECORD (Untitled7)

  • QUESTION_CD (Key) — VARCHAR(255) — Primary key — NOT NULL
  • QUESTION (Field) — VARCHAR(255)
  • RECORD_PD (Field2) — VARCHAR(255)
  • RECORD_RES (Field3) — VARCHAR(255)

SNACK (Untitled8)

  • SNACK_ID (Key) — BIGINT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(255)
  • SNACK_IMG (Field2) — VARCHAR255)
  • DESCRIPTION (Field3) — VARCHAR(255)
  • CREATED_AT (Field4) — TIMESTAMP = CURRENT_TIMESTAMP
  • SNACK_TYPE (Field5) — BIGINT

VIEW_LOG (Untitled3)

  • VIEW_ID (Key) — BIGINT — Primary key — NOT NULL
  • CUSTOM_ID (Key3) — BIGINT(AUTO INCREMENT) — Foreign key → CUSTOM_COCKTAIL.CUSTOM_ID — NOT NULL
  • COCKTIAL_ID (Key2) — BIGINT(AUTO INCREMENT) — Foreign key → COCKTIAL.COCKTIAL_ID — NOT NULL
  • VIEW_DATE (Field) — TIMESTAMP
  • BIRTH (Field2) — VARCHAR(255)
  • GENDER (Field3) — VARCHAR(255)

WEATHER (Untitled9)

  • WEATHER_ID (Key) — VARCHAR(255) — Primary key — NOT NULL
  • WEATHER_CATEGORY (Field) — VARCHAR(5)
  • WEATHER_STATUS (Field2) — VARCHAR(10)