CocktailTags

Tables (6)

COCKTAIL

  • COCKTAIL_ID — NUMBER(5) — Primary key — NOT NULL
  • NAME — VARCHAR2(128) — NOT NULL
  • IMAGE — VARCHAR2(256) — NOT NULL
  • DESC — VARCHAR2(4000)
  • HISTORY_DESC — VARCHAR2(4000)
  • TASTE_DESC — VARCHAR2(4000)
  • BASE_ALCOHOL — VARCHAR2(128)
  • BUILD_METHOD — VARCHAR2(4000)
  • COCKTAIL_GLASS — VARCHAR2(1500)

COCKTAIL_TAG

  • COCKTAIL_ID — NUMBER(5) — Foreign key → COCKTAIL.COCKTAIL_ID — NOT NULL
  • TAG_ID — NUMBER(5) — Foreign key → TAG.TAG_ID — NOT NULL

FAVORITE_COCKTAIL

  • MEMBER_ID — NUMBER(4) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • COCKTAIL_ID — NUMBER(5) — Foreign key → COCKTAIL.COCKTAIL_ID — NOT NULL

FAVORITE_TAGS

  • MEMBER_ID — NUMBER(4) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • TAG_ID — NUMBER(5) — Foreign key → TAG.TAG_ID — NOT NULL

MEMBER

  • MEMBER_ID — NUMBER(4) — Primary key — NOT NULL
  • LOGIN_ID — VARCHAR2(16) — NOT NULL
  • NAME — VARCHAR2(32) — NOT NULL
  • PASSWORD — VARCHAR2(64) — NOT NULL
  • PASSWORD_SALT — VARCHAR2(32) — NOT NULL
  • PERMISSIONS — CHAR(1)

TAG

  • TAG_ID — NUMBER(5) — Primary key — NOT NULL
  • TAG_NAME — VARCHAR2(100)
  • DESC — VARCHAR2(300)
  • CATEGORY — VARCHAR2(60) — NOT NULL