w
Tables (4)
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)