simplebar
Tables (5)
customers (손님정보)
- customerId (Key) — varchar2(30) — Primary key — NOT NULL
drinks (제조술정보)
- drinkName (Key) — varchar2(30) — Primary key — NOT NULL
- drinkComment (Field) — varchar2(1000)
- price (Field2) — number
- indate (Field3) — date
ingredients (원료정보)
- ingredientSeq (Key) — varchar2(30) — Primary key — NOT NULL
- ingredientName (Field2) — varchar2(30)
- ingredientComment (Field) — varchar2(1000)
recipes (레시피정보)
- recipeSeq (Key3) — varhcar2(30) — Primary key — NOT NULL
- drinkName (Key) — varchar2(30) — Foreign key → drinks.drinkName — NOT NULL
- ingredientSeq (Key2) — varchar2(30) — Foreign key → ingredients.ingredientSeq — NOT NULL
- quantity (Field) — number
- indate (Field2) — date
sold (판매정보)
- soldSeq (Key) — varhcar2(30) — Primary key — NOT NULL
- customerId (Key2) — varchar2(30) — Foreign key → customers.customerId — NOT NULL
- drinkName (Key3) — varchar2(30) — Foreign key → drinks.drinkName — NOT NULL
- quantity (Field) — number