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