ㄷㅇㅌㅂㅇㅅㄴ
Tables (4)
airplane
- airplane_id — VARCHAR(50) — Primary key — NOT NULL
- departure_date — DATE — NOT NULL
- departure_time — TIME — NOT NULL
credit_card
- card_number — VARCHAR(50) — Primary key — NOT NULL
- expiry_date — VARCHAR(10) — NOT NULL
- user_id — VARCHAR(50) — Foreign key → member.user_id
member
- user_id — VARCHAR(50) — Primary key — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
seat
- seat_id — VARCHAR(20) — Primary key — NOT NULL
- airplane_id — VARCHAR(50) — Foreign key → airplane.airplane_id — NOT NULL
- grade — VARCHAR(20) — NOT NULL
- reserved_user_id — VARCHAR(50) — Foreign key → member.user_id