기말과제 영문

테이블 (12)

Untitled (member)

  • Key (member_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (email) — char(100)
  • Field (password) — char(100)
  • Field (phone) — char(20)
  • Field (birth_date) — date
  • Field (join_date) — date
  • Key (grade_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL

Untitled (artist)

  • Key (artist_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (name) — char(100)
  • Field (agency) — char(100)
  • Field (debut_date) — date
  • Field (artist_type) — char(10)

Untitled (venue)

  • Key (venue_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (name) — char(100)
  • Field (city) — char(50)
  • Field (address) — text
  • Field (capacity) — integer
  • Field (contact) — char(50)

Untitled (seat)

  • Key (seat_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (section) — char(50)
  • Field (row_no) — char(10)
  • Field (seat_no) — char(10)
  • Field (grade) — char(20)
  • Key (venue_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL

Untitled (concert)

  • Key (concert_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (title) — char(200)
  • Field (concert_datetime) — timestamp
  • Field (bookking_open_datetime) — timestamp
  • Field (run_time_minutes) — integer
  • Field (base_price) — numeric(10)
  • Field (status) — char(20)
  • Key (venue_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL

Untitled (booking)

  • Key (booking_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (booking_datetime) — timestamp
  • Field (payment_method) — char(20)
  • Field (status) — char(20)
  • Field (total_price) — numeric(10)
  • Key (member_id) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Key (concert_id) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Key (site_id) — integer — 외래 키 → Untitled.Key — NOT NULL

Untitled (booking_site)

  • Key (site_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (site_name) — char(100)
  • Field (url) — char(200)
  • Field (company) — char(100)
  • Field (contact) — char(50)

Untitled (lineup)

  • Key (concert_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Key (artist_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Field (role) — char(20)

Untitled (booking_seat)

  • Key (booking_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Key (seat_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL

Untitled (grade_rule)

  • Key (grade_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (grade_name) — VARCHAR(20)
  • Field (min_spending) — NUMERIC(10)
  • Field (period_months) — INTEGER

Untitled (price_policy)

  • Key (price_policy_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (seat_grade) — VARCHAR(20)
  • Field (price) — NUMERIC(10)
  • Key (concert_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (member_grade_history)

  • Key (history_id) — SERIAL PRIMARY KEY — 기본 키 — NOT NULL
  • Field (start_date) — date
  • Field (end_date) — date
  • Field (spending) — NUMERIC(10)
  • Field (updated_at) — TIMESTAMP
  • Key (member_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Key (grade_id) — SERIAL PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL