SHARE
TWEET

cps510 erweqrweqrqwer

a guest Nov 19th, 2019 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE CUSTOMER_F
  2. (
  3.   ID NUMBER NOT NULL
  4. , FIRST_NAME VARCHAR2(200 BYTE)
  5. , LAST_NAME VARCHAR2(200 BYTE)
  6. , EMAIL VARCHAR2(200 BYTE)
  7. , PHONE VARCHAR2(50 BYTE)
  8. , STREET_NAME VARCHAR2(200 BYTE)
  9. , STREET_NO VARCHAR2(200 BYTE)
  10. , CITY VARCHAR2(200 BYTE)
  11. , STATE VARCHAR2(200 BYTE)
  12. , POSTAL_CODE VARCHAR2(50 BYTE)
  13. , CONSTRAINT CUSTOMERS_PK PRIMARY KEY (
  14.     ID
  15.   )
  16. );
  17.  
  18.  
  19.  
  20. CREATE TABLE ITEMS
  21. (
  22.   ITEM_ID NUMBER NOT NULL
  23. , AISLE NUMBER
  24. , BINCAP NUMBER
  25. , PRICE NUMBER
  26. , ITEM_NAME VARCHAR2(300 BYTE)
  27. , STOCK NUMBER
  28. , INSTOCK VARCHAR2(100 BYTE)
  29. , CATEGORY VARCHAR2(100 BYTE)
  30. , COLOR VARCHAR2(100 BYTE)
  31. , ITEM_SIZE VARCHAR2(20 BYTE)
  32. , DISCOUNTED VARCHAR2(50 BYTE)
  33. , DISCOUNT_AMOUNT NUMBER
  34. , ORDER_DATE DATE
  35. , GENDER VARCHAR2(50 BYTE)
  36. , STORE_ID NUMBER
  37. , CONSTRAINT ITEMS_PK PRIMARY KEY
  38.   (
  39.     ITEM_ID
  40.   )
  41. );
  42.  
  43. CREATE TABLE CC
  44. (
  45.   CC_NUM NUMBER NOT NULL
  46. , ISSUER VARCHAR(25)
  47. , SECURITY_CODE NUMBER
  48. , FIRST_NAME VARCHAR2(200)
  49. , LAST_NAME VARCHAR2(200)
  50. , EXPIRY DATE
  51. , CUSTOMER_ID NUMBER
  52. , CONSTRAINT CREDIT_CARDS_PK PRIMARY KEY
  53.   (
  54.     CC_NUM
  55.   )
  56. );
  57.  
  58. CREATE TABLE BILL
  59. (
  60.   BILL_ID NUMBER NOT NULL
  61. , PURCHASE_DATE DATE
  62. , PURCHASE_METHOD VARCHAR2(50 BYTE)
  63. , CUSTOMER_ID NUMBER NOT NULL
  64. , CONSTRAINT BILLS_PK PRIMARY KEY
  65.   (
  66.     BILL_ID
  67.   )
  68. );
  69.  
  70. CREATE TABLE STORE (STORE_ID NUMBER NOT NULL, STREET_NAME VARCHAR(200), STREET_NO VARCHAR(200), POSTAL_CODE VARCHAR(200), CONSTRAINT STORE_PK PRIMARY KEY (STORE_ID));
  71.  
  72.  
  73. CREATE TABLE BILLDETAIL (BILL_DETAIL_ID NUMBER NOT NULL, BILL_ID NUMBER NOT NULL, PRICE NUMBER, AMOUNT NUMBER, CONSTRAINT BILLDETAIL_PK PRIMARY KEY ( BILL_DETAIL_ID ));
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top