글로벌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