give me a gift_project

Tables (6)

BASKETS (Untitled4)

  • BASKET_ID (Key) — Primary key — NOT NULL
  • DELETE_FLAG (Field)

CATEGORIES (Untitled3)

  • CATEGORY_ID (Key) — PK — Primary key — NOT NULL
  • NAME (Field)

GIFTS (Untitled)

  • GIFT_ID (Key) — PK — Primary key — NOT NULL
  • GIFT_DATE (Field)
  • GIFT_STATUS (Field2)
  • MEMBER_ID (Key2) — FK — Foreign key → MEMBERS.MEMBER_ID — NOT NULL
  • RECEIVED_ID (Key4) — FK — Foreign key → MEMBERS.MEMBER_ID — NOT NULL

GIFT_ITEMS (Untitled5)

  • GIFT_ITME_ID (Key3) — PK — Primary key — NOT NULL
  • PRICE (Field)
  • COUNT (Field2)
  • GIFT_ID (Key2) — PK — Foreign key → GIFTS.GIFT_ID — NOT NULL
  • ITEM_ID (Key) — PK — Foreign key → ITEMS.ITEM_ID — NOT NULL
  • BASKET_ID (Key4) — Foreign key → BASKETS.BASKET_ID — NOT NULL

ITEMS (Untitled2)

  • ITEM_ID (Key) — PK — Primary key — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • STOCK_QUANTITY (Field3)
  • CATEGORY_ID (Key2) — PK — Foreign key → CATEGORIES.CATEGORY_ID — NOT NULL

MEMBERS (TABLE)

  • MEMBER_ID (Key) — PK — Primary key — NOT NULL
  • USERNAME (Field6)
  • PASSWORD (Field7)
  • ROLE (Field8)
  • NAME (Field)
  • SEX (Field2)
  • BIRTH_DATE (Field3)
  • MESSAGE (Field4)
  • GIFT_RECEIVE_STATUS (Field5)
  • BASKET_ID (Key2) — Foreign key → BASKETS.BASKET_ID — NOT NULL