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)