delivery-moa

Tables (17)

chat

  • id — NUMBER
  • room_id — NUMBER
  • chat — VARCHAR2(1000)
  • created_at — DATE
  • user_id — NUMBER

chat_report

  • id — NUMBER
  • chat_id — NUMBER
  • reason — VARCHAR2(1000)
  • reported_by — NUMBER
  • created_at — DATE
  • room_id — NUMBER

image

  • id — NUMBER
  • bucket — VARCHAR2(255)
  • folder — VARCHAR2(255)
  • filename — VARCHAR2(255)
  • file_path — VARCHAR2(5000)

menu

  • id — NUMBER
  • menu_category_id — NUMBER
  • store_id — NUMBER
  • image_id — NUMBER
  • menu_name — VARCHAR2(255)
  • menu_price — NUMBER

menu_category

  • id (menu_category_id) — NUMBER — Primary key
  • category — VARCHAR2(100)
  • num — NUMBER

menu_category_img

  • id — NUMBER — Primary key
  • menu_category_id — NUMBER — Foreign key → menu_category.id
  • file_path — VARCHAR2(5000)

orders

  • order_id — NUMBER — Primary key
  • user_id — NUMBER — Foreign key → users.user_id
  • room_id — NUMBER — Foreign key → room.room_id
  • store_id — NUMBER — Foreign key → store.store_id
  • ROOM_ORDER — VARCHAR2(4000)
  • total_price — NUMBER
  • created_at — TIMESTAMP

payment

  • id — NUMBER — Primary key
  • user_id — NUMBER — Foreign key → users.user_id
  • status — VARCHAR2(4000)
  • amount — NUMBER

popular

  • id — NUMBER — Primary key
  • title — VARCHAR2(255)
  • price — NUMBER
  • store_id — NUMBER

popular_img

  • id — NUMBER — Primary key
  • popular_id — NUMBER — Foreign key → popular.id
  • file_path — VARCHAR2(5000)

qna

  • id — NUMBER — Primary key
  • user_id — NUMBER — Foreign key → users.user_id
  • title — VARCHAR2(255)
  • q_contents — VARCHAR2(2000)
  • q_answer — VARCHAR2(2000)
  • created_at — TIMESTAMP

review

  • id — NUMBER — Primary key
  • user_id — NUMBER — Foreign key → users.user_id
  • order_id — NUMBER — Foreign key → orders.order_id
  • user_id (user_id2) — NUMBER — Foreign key → orders.user_id
  • room_id — NUMBER — Foreign key → orders.room_id
  • store_id — NUMBER — Foreign key → orders.store_id
  • score — NUMBER
  • comments — VARCHAR2(2000)
  • created_at — TIMESTAMP

room

  • room_id — NUMBER — Primary key
  • store_id — NUMBER — Foreign key → store.store_id
  • room_name — VARCHAR2(255)
  • room_address — VARCHAR2(1000)
  • max_people — NUMBER
  • users — VARCHAR2(4000)
  • leader_id — NUMBER
  • status — VARCHAR2(50)
  • created_at — TIMESTAMP
  • room_address_detail — VARCHAR2(1000)

room_join

  • id — NUMBER
  • room_id — NUMBER
  • users_id — NUMBER
  • joined_at — TIMESTAMP
  • status — VARCHAR2(50)

store

  • store_id — NUMBER — Primary key
  • user_id — NUMBER — Foreign key → users.user_id
  • menu_category_id — NUMBER
  • store_name — VARCHAR2(255)
  • store_address — VARCHAR2(1000)
  • min_price — NUMBER
  • tel — VARCHAR2(50)
  • store_img_path — VARCHAR2(5000)

store_menu_img

  • id — NUMBER — Primary key
  • store_id — NUMBER — Foreign key → store.store_id
  • file_path — VARCHAR2(5000)

users

  • user_id — NUMBER — Primary key
  • nickname — VARCHAR2(100)
  • user_rating — NUMBER
  • role — VARCHAR2(100)
  • created_at — TIMESTAMP
  • address — VARCHAR2(255)
  • profile_url — VARCHAR2(1000)
  • room_address_detail — VARCHAR2(255)
  • status — VARCHAR2(20)
  • email — VARCHAR2(255)
  • password — VARCHAR2(255)
  • phone_num — VARCHAR2(20)