스터디카페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