w

Tables (4)

Untitled

    expire_date (유통기한)

    • id (Key) — NOT NULL, AUTO INCREMENT — Primary key — NOT NULL
    • item_code (Key2) — NOT NULL — Foreign key → item.id — NOT NULL
    • expire_date (Field2) — DEFAULT = NULL
    • counts (Field) — DEFAULT = 0

    item (상품)

    • id (Key) — NOT NULL, AUTO INCREMENT — Primary key — NOT NULL
    • item_code (Field) — NOT NULL
    • name (Field2) — NOT NULL
    • display_location (Field3) — DEFAULT = 0
    • warehouse_location (Field4) — DEFAULT = 0
    • expire_date (Field5) — DEFAULT = NULL
    • type (Field6) — DEFAULT = -1(0 = ROOM_TEMPERATURE, 1 = LOW_TEMPERATURE, 2 = FROZEN, 3 = NON-FOOD)
    • counts (Field7) — DEFAULT = 0

    user (회원)

    • id (Key) — NOT NULL, AUTO INCREMENT — Primary key — NOT NULL
    • site_domain (Field) — NOT NULL(0 = KAKAO, 1 = NAVER, 2 = GOOGLE)
    • is_admin (Field2) — NOT NULL(0 = USER, 1 = ADMIN)