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