기말과제 영문
테이블 (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