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)