velogExample

Tables (5)

Cookie (COOKIE)

  • id (COOKIE_ID) — BIGINT — Primary key — NOT NULL
  • price (PRICE) — INTEGER
  • taste (TASTE) — VARCHAR(255)

Delivery (DELIVERY)

  • id (DELIVERY_ID) — BIGINT — Primary key — NOT NULL
  • status (STATUS) — VARCHAR(255)

Order (ORDERS)

  • id (ORDER_ID) — BIGINT — Primary key — NOT NULL
  • userId (USER_ID) — BIGINT — Foreign key → User.id — NOT NULL
  • id (DELIVERY_ID) — BIGINT — Foreign key → Delivery.id — NOT NULL

OrderCookie (ORDER_COOKIE)

  • id (ORDER_COOKIE_ID) — BIGINT — Primary key — NOT NULL
  • orderId (ORDER_ID) — BIGINT — Foreign key → Order.id — NOT NULL
  • cookieId (COOKIE_ID) — BIGINT — Foreign key → Cookie.id — NOT NULL

User (USER)

  • id (USER_ID) — BIGINT — Primary key — NOT NULL
  • name (USERNAME) — VARCHAR(255)