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