스터디카페erd
테이블 (7)
alarm
- alarm_id — NUMBER
- user_id — NUMBER — NOT NULL
- alarm_content — VARCHAR2(500) — NOT NULL
- alarm_time — TIMESTAMP — NOT NULL
- alarm_type — VARCHAR2(20) — NOT NULL
coupon
- cp_id — NUMBER
- user_id — NUMBER — NOT NULL
- cp_status — VARCHAR2(20) — NOT NULL
- discount_rate — NUMBER(5,2) — NOT NULL
- exp_date — DATE — NOT NULL
payment
- pay_id — NUMBER
- rv_id — NUMBER — NOT NULL
- pay_amount — NUMBER(10,2) — NOT NULL
- pay_date — TIMESTAMP — NOT NULL
- pay_method — VARCHAR2(20) — NOT NULL
reservation
- rv_id — NUMBER
- user_id — NUMBER — NOT NULL
- seat_id — NUMBER — NOT NULL
- rv_start_time — TIMESTAMP — NOT NULL
- rv_end_time — TIMESTAMP — NOT NULL
- rv_status — VARCHAR2(20) — NOT NULL
seat
- seat_id — NUMBER
- seat_zone — VARCHAR2(1) — NOT NULL
- seat_status — VARCHAR2(20) — NOT NULL
user
- user_id — NUMBER
- user_name — VARCHAR2(50) — NOT NULL
- user_email — VARCHAR2(100) — NOT NULL
- user_pn — VARCHAR2(15) — NOT NULL
- user_pw — VARCHAR2(255) — NOT NULL
zone_attributes
- seat_zone — VARCHAR2(1)
- seat_type — VARCHAR2(20) — NOT NULL