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