title: PostgreSQL or DBMS question. Is this a physical or logical schema?
body: <p>The schema of the database is shown below:</p>
  
  <p>Country</p>
  
  <pre><code>name: varchar (35)
  cont: varchar (35)
  pop: real
  GDP: real
  life_exp: real
  shape: char(15)
  </code></pre>
  
  <p>City</p>
  
  <pre><code>name: varchar (35)
  country: varchar(35)
  pop: real
  capital: char(1)
  shape: char (15)
  </code></pre>
  
  <p>River</p>
  
  <pre><code>name: varchar(35)
  origin: varchar(35)
  length: integer
  shape: char(15)
  </code></pre>
  
  <p>I think it is a logical/conceptual schema but the person who graded my assignment said it was a physical schema.  I thought physical schema referred to specific hardware,software,file paths etc.  The logical schema is mapped to the physical schema usually in some sort of table format.  Am I right? </p>