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