글로벌IT인재개발원3차파이널프로젝트

테이블 (19)

ADDRESS

  • address_id — NUMBER
  • APP_USER_id — NUMBER — NOT NULL
  • address_detail — VARCHAR2(255) — NOT NULL
  • address_nickname — VARCHAR2(50)
  • address_entrance_method — VARCHAR2(100)
  • address_is_default — CHAR(1)
  • address_created_date — DATE
  • address_visible — CHAR(1)

APP_USER

  • APP_USER_id — NUMBER
  • APP_USER_nickname — VARCHAR2(50) — NOT NULL
  • APP_USER_password — VARCHAR2(255) — NOT NULL
  • APP_USER_name — VARCHAR2(100) — NOT NULL
  • APP_USER_birthday — DATE
  • APP_USER_gender — CHAR(1)
  • APP_USER_mobile — VARCHAR2(10) — NOT NULL
  • APP_USER_email — VARCHAR2(100) — NOT NULL
  • APP_USER_created_date — DATE
  • APP_USER_status — CHAR(1)

APP_USER_coupon

  • APP_USER_coupon_id — NUMBER
  • APP_USER_id — NUMBER — NOT NULL
  • coupon_id — NUMBER — NOT NULL
  • used — CHAR(1)

ORDER

  • order_id — NUMBER
  • APP_USER_id — NUMBER — NOT NULL
  • store_id — NUMBER — NOT NULL
  • address_id — NUMBER — NOT NULL
  • order_address_snapshot — VARCHAR2(255)
  • order_total_price — NUMBER — NOT NULL
  • order_delivery_fee — NUMBER
  • order_status — VARCHAR2(50)
  • order_date — DATE

cart

  • cart_id — NUMBER
  • APP_USER_id — NUMBER — NOT NULL
  • store_id — NUMBER — NOT NULL
  • cart_update_at — DATE

cart_item

  • cart_item_id — NUMBER
  • cart_id — NUMBER — NOT NULL
  • menu_id — NUMBER — NOT NULL
  • cart_item_quantity — NUMBER

coupon

  • coupon_id — NUMBER
  • name — VARCHAR2(100) — NOT NULL
  • discount_type — VARCHAR2(50) — NOT NULL
  • discount_value — NUMBER — NOT NULL
  • expired_at — DATE — NOT NULL

favorite_store

  • favorite_id — NUMBER
  • APP_USER_id — NUMBER — NOT NULL
  • store_id — NUMBER — NOT NULL

menu

  • menu_id — NUMBER
  • store_id — NUMBER — NOT NULL
  • menu_category_id — NUMBER — NOT NULL
  • menu_name — VARCHAR2(100) — NOT NULL
  • menu_price — NUMBER — NOT NULL
  • menu_description — VARCHAR2(500)
  • menu_is_available — CHAR(1)

menu_category

  • menu_category_id — NUMBER
  • store_id — NUMBER — NOT NULL
  • menu_category_name — VARCHAR2(100) — NOT NULL

menu_option

  • menu_option_id — NUMBER
  • menu_option_group_id — NUMBER — NOT NULL
  • menu_option_name — VARCHAR2(100) — NOT NULL
  • menu_option_price — NUMBER

menu_option_group

  • menu_option_group_id — NUMBER
  • menu_id — NUMBER — NOT NULL
  • menu_option_group_name — VARCHAR2(100) — NOT NULL
  • menu_option_group_required — CHAR(1)

notification

  • notification_id — NUMBER
  • APP_USER_id — NUMBER — NOT NULL
  • notification_message — VARCHAR2(500) — NOT NULL
  • notification_is_read — CHAR(1)
  • notification_created_at — DATE

order_item

  • order_item_id — NUMBER
  • order_id — NUMBER — NOT NULL
  • order_item_name — VARCHAR2(100) — NOT NULL
  • order_item_price — NUMBER — NOT NULL
  • order_item_quantity — NUMBER — NOT NULL

order_option

  • order_option_id — NUMBER
  • order_item_id — NUMBER — NOT NULL
  • order_option_name — VARCHAR2(100) — NOT NULL
  • order_option_extra_price — NUMBER

payment

  • payment_id — NUMBER
  • order_id — NUMBER — NOT NULL
  • payment_method — VARCHAR2(50) — NOT NULL
  • payment_amount — NUMBER — NOT NULL
  • payment_status — VARCHAR2(50)
  • payment_paid_at — DATE

review

  • review_id — NUMBER
  • order_id — NUMBER — NOT NULL
  • APP_USER_id — NUMBER — NOT NULL
  • store_id — NUMBER — NOT NULL
  • review_rating — NUMBER(2,1) — NOT NULL
  • review_content — VARCHAR2(1000)
  • review_created_at — DATE

store

  • store_id — NUMBER
  • store_owner_name — VARCHAR2(100) — NOT NULL
  • store_name — VARCHAR2(100) — NOT NULL
  • store_category — VARCHAR2(50) — NOT NULL
  • store_phone — NUMBER(10) — NOT NULL
  • store_min_order — NUMBER
  • store_max_dist — NUMBER
  • store_delivery_fee — NUMBER
  • store_open_time — NUMBER(4)
  • store_close_time — NUMBER(4)
  • store_rating — NUMBER(3,2)
  • store_total_order — NUMBER
  • store_recent_order — NUMBER
  • store_open_status — CHAR(1)
  • store_intro — VARCHAR2(4000)

store_image

  • store_image_id — NUMBER
  • store_id — NUMBER — NOT NULL
  • store_image_url — VARCHAR2(500) — NOT NULL