asdf

Tables (11)

basket

  • seq — int
  • user_seq — int — Foreign key → users.seq
  • menu_seq — int — Foreign key → menu.seq
  • count — short
  • total_amount — int

chat_info

  • seq — int
  • name — varchar(255) — 식당이름+마감시간+인원
  • adress — varchar(255)
  • latitude — decimal
  • longitude — decimal
  • restaurant_seq — long
  • personnel — short
  • created_dt — datetime
  • order_time — datetime

chat_message

  • seq — long
  • content — text — NOT NULL
  • image — img
  • time — currenttime — NOT NULL
  • users_seq — int — Foreign key → users.seq
  • chat_room — int — Foreign key → chat_info.seq
  • send_dt — datetime
  • read_check — boolean — NOT NULL — 0->unread, 1->read
  • read_dt — time — NOT NULL

chat_room

  • seq — long
  • users_seq — int — Foreign key → users.seq
  • chat_room — int — Foreign key → chat_info.seq
  • created_dt — datetime

menu

  • seq — int — Foreign key → restaurant.menu_seq
  • category — text — NOT NULL
  • name — text — NOT NULL
  • img — varchar(255)
  • price — text — NOT NULL
  • side_menu_seq — int
  • count — short

order

  • user_seq — int — Foreign key → users.seq
  • menu_seq — int — Foreign key → menu.seq
  • chat_room_seq — long — Foreign key → chat_room.seq
  • payType — text
  • payment_method — text
  • pay_status — short
  • pay_datetime — datetime
  • total_amount — int
  • group_order_status — short
  • restaurant_seq — long

owner

  • seq — int — Primary key
  • name — varchar(255)
  • profile — jpg
  • created_dt — time — NOT NULL
  • acount_name — varchar(255)
  • acount_num — int

restaurant

  • seq — long
  • name — varchar(255)
  • logo_img — varchar(255)
  • category — varchar(255)
  • delivery_price — int
  • max_member — short
  • menu_seq — int
  • phone — int
  • adress — varchar(255)
  • latitude — decimal
  • longitude — decimal
  • seq (seq3) — int — Foreign key → owner.seq

reviews

  • seq — int
  • restaurant_seq — long — Foreign key → restaurant.seq
  • users_seq — int — Foreign key → users.seq
  • grade — float — NOT NULL
  • content — text — NOT NULL
  • time — currenttime — NOT NULL

side_menu

  • seq — int — Foreign key → menu.side_menu_seq
  • category — text — NOT NULL
  • name — text — NOT NULL
  • price — text — NOT NULL
  • count — short

users

  • seq — int
  • name — varchar(255)
  • profile — jpg
  • created_dt — time — NOT NULL
  • my_point — int
  • acount_name — varchar(255)
  • acount_num — int
  • adress — varchar(255)