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)