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)