SQLITE 실습

테이블 (11)

albums (Untitled)

  • AlbumId (Key) — int — 기본 키 — NOT NULL
  • Title (Field) — VARCHAR(160) — NOT NULL
  • ArtistId (Key2) — int — 외래 키 → artists.ArtistId — NOT NULL

artists (Untitled2)

  • ArtistId (Key) — int — 기본 키 — NOT NULL
  • Name (Field) — VARCHAR(120) — NOT NULL

customers (Untitled8)

  • CustomerId (Key) — int — 기본 키 — NOT NULL
  • FirstName (Field) — VARCHAR(40)
  • LastName (Field2) — VARCHAR(20)
  • Company (Field3) — VARCHAR(80)
  • Address (Field4) — VARCHAR(70)
  • City (Field5) — VARCHAR(40)
  • State (Field6) — VARCHAR(40)
  • Country (Field7) — VARCHAR(40)
  • PostalCode (Field8) — VARCHAR(10)
  • Phone (Field9) — VARCHAR(24)
  • Fax (Field10) — VARCHAR(24)
  • Email (Field11) — int
  • SupportRepId (Key2) — int — 외래 키 → employees.EmployeeId — NOT NULL

employees (Untitled9)

  • EmployeeId (Key) — int — 기본 키 — NOT NULL
  • LastName (Field) — VARCHAR(20)
  • FirstName (Field2) — VARCHAR(20)
  • Title (Field3) — VARCHAR(30)
  • ReportsTo (Field4) — int
  • BirthDate (Field5) — DATETIME
  • HireDate (Field6) — DATETIME
  • Address (Field7) — VARCHAR(70)
  • City (Field8) — VARCHAR(40)
  • State (Field9) — VARCHAR(40)
  • Country (Field10) — VARCHAR(40)
  • PostalCode (Field11) — VARCHAR(10)
  • Phone (Field12) — VARCHAR(24)
  • Fax (Field13) — VARCHAR(24)
  • Email (Field14) — VARCHAR(60)

genres (Untitled4)

  • GenreId (Key) — int — 기본 키 — NOT NULL
  • Name (Field) — VARCHAR(120)

invoice_items (Untitled11)

  • InvoiceLineId (Key) — int — 기본 키 — NOT NULL
  • InvoiceId (Key2) — int — 외래 키 → invoices.InvoiceId — NOT NULL
  • TrackId (Key3) — int — 외래 키 → tracks.TrackId — NOT NULL
  • UnitPrice (Field) — NUMERIC(10,2)
  • Quantity (Field2) — int

invoices (Untitled10)

  • InvoiceId (Key) — int — 기본 키 — NOT NULL
  • InvoiceDate (Field) — DATETIME
  • CustomerId (Key2) — int — 외래 키 → customers.CustomerId — NOT NULL
  • BillingAddress (Field2) — VARCHAR(70)
  • BillingCity (Field3) — VARCHAR(40)
  • BillingState (Field4) — VARCHAR(40)
  • BillingCountry (Field5) — VARCHAR(40)
  • BillingPostalCode (Field6) — VARCHAR(10)
  • Total (Field7) — NUMERIC(10,2)

media_types (Untitled5)

  • MediaTypeId (Key) — int — 기본 키 — NOT NULL
  • Name (Field) — VARCHAR(120)

playlist_track (Untitled7)

  • PlaylistId (Key) — int — 외래 키 → playlists.PlaylistId — NOT NULL
  • TrackId (Key2) — int — 외래 키 → tracks.TrackId — NOT NULL

playlists (Untitled6)

  • PlaylistId (Key) — int — 기본 키 — NOT NULL
  • Name (Field) — VARCHAR(120)

tracks (Untitled3)

  • TrackId (Key) — int — 기본 키 — NOT NULL
  • Name (Field) — VARCHAR(200)
  • AlbumId (Key2) — int — 외래 키 → albums.AlbumId — NOT NULL
  • Composer (Field4) — VARCHAR(220)
  • Milliseconds (Field3) — int
  • Bytes (Field5) — int
  • UnitPrice (Field6) — NUMERIC(10,2)
  • GenreId (Key3) — int — 외래 키 → genres.GenreId — NOT NULL
  • MediaTypeId (Key4) — int — 외래 키 → media_types.MediaTypeId — NOT NULL