PopupApp

Tables (9)

Congestion (Untitled7)

  • congestion_id (Key) — number — Primary key — NOT NULL
  • popup_info_id (Key2) — number — Foreign key → PopupInfo.popup_info_id — NOT NULL
  • con_reason_id (Key3) — Foreign key → Congestion_reason.con_reason_id — NOT NULL
  • con_reason_etc_text (Field5) — varchar2(500)
  • status (Field) — varchar2(100)
  • reason (Field2) — varchar2(500)
  • updated_at (Field4) — date
  • updated_by (Field3) — number
  • congestion_date (Field6) — date

Congestion_reason (Untitled3)

  • con_reason_id (Key) — Primary key — NOT NULL
  • con_reason_code (Field) — number
  • con_reason_text (Field2) — varchar2(500)

Member (Untitled4)

  • member_id (Key) — number — Primary key — NOT NULL
  • role_id (Key2) — number — Foreign key → Role.role_id — NOT NULL
  • login_id (Field) — varchar2(100)
  • password (Field2) — varchar2(100)
  • name (Field3) — varchar2(50)
  • email (Field4) — varchar2(100)
  • zipcode (Field6) — VARCHAR2(10)
  • roadAddress (Field7) — VARCHAR2(200)
  • detailAddress (Field8) — VARCHAR2(200)
  • gender (Field5) — char(1)
  • birth_date (Field9) — date

Member_like (Untitled6)

  • member_like_id (Key3) — number — Primary key — NOT NULL
  • member_id (Key) — number — Foreign key → Member.member_id — NOT NULL
  • popup_info_id (Key2) — number — Foreign key → PopupInfo.popup_info_id — NOT NULL

PopupInfo (Untitled)

  • popup_info_id (Key) — number — Primary key — NOT NULL
  • member_id (Key2) — number — Foreign key → Member.member_id — NOT NULL
  • title (Field) — varchar2(300)
  • period (Field2) — varchar2(100)
  • place (Field3) — varchar2(200)
  • main_img (Field4) — varchar2(500)
  • evnet_text (Field5) — clob
  • notice_text (Field6) — clob\

Popup_product (Untitled2)

  • popup_product_id (Key) — number — Primary key — NOT NULL
  • popup_info_id (Key2) — number — Foreign key → PopupInfo.popup_info_id — NOT NULL
  • brand (Field2) — varchar2(100)
  • name (Field3) — varchar2(200)
  • price (Field4) — varchar2(50)
  • imgage_url (Field5) — varchar2(500)

Role (Untitled5)

  • role_id (Key) — number — Primary key — NOT NULL
  • role_name (Field) — varchar2(100)
  • role_info (Field2) — varchar2(200)

popup_notice (Untitled9)

  • popup_notice_id (Key) — number — Primary key — NOT NULL
  • member_id (Key3) — number — Foreign key → Member.member_id — NOT NULL
  • popup_info_id (Key2) — number — Foreign key → PopupInfo.popup_info_id — NOT NULL
  • title (Field) — varchar2(200)
  • content (Field2) — clob

popup_qna (Untitled8)

  • popup_qna_id (Key) — number — Primary key — NOT NULL
  • popup_info_id (Key2) — number — Foreign key → PopupInfo.popup_info_id — NOT NULL
  • member_id (Key3) — number — Foreign key → Member.member_id — NOT NULL
  • title (Field) — varchar2(200)
  • question (Field2) — clob
  • answer (Field3) — clob