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)