키오스크제작
테이블 (3)
Mnues (Menus)
- StoreId (storeId) — VARCHAR(255) — 기본 키 — NOT NULL
- StoreName (storename) — VARCHAR(255) — 외래 키 → Store.StoreName — NOT NULL
- StoreId (storeId2) — VARCHAR(225) — 외래 키 → Store.StoreId
- Name (name) — VARCHAR(100)
- Price (price) — INT
- Description (description) — TEXT
- Image (image_url) — TEXT
- Category (category) — INT
- Store_id (store_id) — INT
- Stock (stock) — Boolean
Store (Untitled2)
- StoreName (storename) — VARCHAR(255) — 기본 키 — NOT NULL
- StoreId (storeId) — VARCHAR(225) — 기본 키
- UserId (userId) — VARCHAR(255) — 외래 키 → User.UserId — NOT NULL
- Addreass (address) — VARCHAR(255)
- City (city) — VARCHAR(100)
- District (district) — VARCHAR(100)
- Detail_Add (detail_add) — VARCHAR(100)
- PhoneNumber (phoneNumber)
User (Untitled)
- UserId (userId) — VARCHAR(255) — 기본 키 — NOT NULL
- Password (password) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- StoreName (storename) — VARCHAR(255)