subway mini project

Tables (9)

tb_basket (Untitled2)

  • BAS_number (Key) — NUMBER(20) — Primary key — NOT NULL
  • sumcode (Field) — NUMBER(10)
  • BAS_quantity (Field3) — VARCHAR(10)
  • MEM_id (Key2) — VARCHAR(10) — Foreign key → tb_member.MEM_id — NOT NULL

tb_coupon (Untitled8)

  • COU_number (Key) — VARCHAR2(10) — Primary key — NOT NULL
  • COU_name (Field) — VARCHAR2(50)
  • COU_discount (Field2) — NUMBER(10)
  • COU_expiry (Field3) — DATE

tb_delivery (Untitled3)

  • DEL_number (Key) — VARCHAR2(10) — Primary key — NOT NULL
  • ORD_number (Field) — NUMBER(14)
  • DEL_address (Field2) — VARCHAR2(200)
  • DEL_current (Field3) — VARCHAR(20)

tb_lab (Untitled9)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

tb_member (Untitled)

  • MEM_id (Key) — VARCHAR(10) — Primary key — NOT NULL
  • MEM_name (Field) — VARCHAR2
  • MEM_password (Field2) — VARCHAR2
  • MEM_email (Field3) — VARCHAR2
  • MEM_number (Field4) — VARCHAR2
  • MEM_address (Field5) — VARCHAR2

tb_morningmenu (Untitled6)

  • MOR_code (Key) — CHAR(6) — Primary key — NOT NULL
  • MOR_kind (Field) — CHAR(3)
  • MOR_menu (Field2) — VARCHAR(2)
  • MOR_photo (Field3) — BLOB
  • MOR_price (Field4) — NUMBER(10)
  • MOR_description (Field5) — VARCHAR2(500)

tb_restaurant (Untitled7)

  • RES_code (Key) — VARCHAR2(10) — Primary key — NOT NULL
  • RES_name (Field) — VARCHAR2(50)
  • RES_address (Field2) — VARCHAR2(200)
  • RES_number (Field3) — NUMBER(20)
  • RES_minamount (Field10) — NUMBER(4)
  • RES_tip (Field4) — NUMBER(4)
  • RES_minminute (Field5) — VARCHAR2(20)
  • RES_maxminute (Field6) — VARCHAR2(20)
  • RES_operatingtime (Field7) — VARCHAR2(100)
  • RES_closeddays (Field8) — VARCHAR2(100)
  • RES_deliveryarea (Field9) — VARCHAR2(100)
  • RES_service (Field11) — VARCHAR(2000)
  • RES_latitude (Field12) — number(11, 8)
  • RES_longitude (Field13) — number(11, 8)

tb_sauce (Untitled4)

  • SAU_code (Key) — CHAR — Primary key — NOT NULL
  • SAU_menu (Field) — VARCHAR2(50)

tb_vegetable (Untitled5)

  • VEG_code (Key) — VARCHAR2(10) — Primary key — NOT NULL
  • VEG_menu (Field) — VARCHAR2(50)