SikShokk
Tables (7)
Member (Untitled)
- Code_number (id) — INT — Primary key — NOT NULL
- Real_name (name) — VARCHAR(255)
- Gender (gender) — ENUM('남','여')
- Nickname (nickname) — VARCHAR(255)
- Userid (userid) — VARCHAR(255)
- Password (pw) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Phone (phone) — VARCHAR(25)
- Yourmoney (point) — INT
Menu (Untitled5)
- Menu_number (menuid) — INT — Primary key — NOT NULL
- Menu_name (menuname) — VARCHAR(255)
- Menu_price (price) — INT
- Menu_content (content) — VARCHAR(255)
- Menu_img (img) — VARCHAR(255)
Order (Untitled2)
- Order_number (ordernum) — INT — Primary key
- Order_date (date) — DATE
- Order_time (time) — STRING(30)
- Order_user (orderer) — STRING(255)
Owner (CopyOfUntitled)
- Code_number (id) — INT — Primary key — NOT NULL
- Real_name (name) — VARCHAR(255)
- Gender (gender) — ENUM('남','여')
- Nickname (nickname) — VARCHAR(255)
- Userid (userid) — VARCHAR(255)
- Password (pw) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Phone (phone) — VARCHAR(25)
- Business_number (brn) — VARCHAR(15)
- Shopname (shopname) — VARCHAR(255)
- Shop_address (address) — VARCHAR(255)
Review (Untitled7)
- Review_number (reviewid) — INT — Primary key — NOT NULL
- Review_writer (nickname) — VARCHAR(255)
- Review_date (date) — DATE
- Review_content (content) — VARCHAR(255)
- Review_img_route (img) — VARCHAR(255)
- Shops_score (score) — INT
Sales (Untitled3)
- Shop_info (shop) — VARCHAR(255)
- Month_sales (month) — INT
- Year_sales (year) — INT
- Day_sales (day) — INT
Shop (Untitled6)
- Business_number (brn) — VARCHAR(15) — Primary key — NOT NULL
- Shopname (shopname) — VARCHAR(255)
- Shop_type (type) — VARCHAR(255)