shinhan
Tables (17)
account
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- account_number — VARCHAR(50)
- INDEX — (`user_id`)
building
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
classroom
- id — INT — Primary key — NOT NULL
- building_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- INDEX — (`building_id`)
enroll
- id — INT — Primary key — NOT NULL
- lecture_id — INT — NOT NULL
- user_id — INT — NOT NULL
- INDEX — (`lecture_id`)
- INDEX — (`user_id`)
friend
- user1_id — INT — Primary key — NOT NULL
- user2_id — INT — Primary key — NOT NULL
group_order
- id — INT — Primary key — NOT NULL
- pick_up_zone_id — INT — NOT NULL
- status — VARCHAR(50)
- reg_date — DATETIME
- INDEX — (`pick_up_zone_id`)
lecture
- id — INT — Primary key — NOT NULL
- classroom_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- INDEX — (`classroom_id`)
lecture_time
- id — INT — Primary key — NOT NULL
- lecture_id — INT — NOT NULL
- day_of_the_week — VARCHAR(10) — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- INDEX — (lecture_id)
menu
- id — INT — Primary key — NOT NULL
- restaurant_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INT
- INDEX — (`restaurant_id`)
order_item
- id — INT — Primary key — NOT NULL
- menu_id — INT — NOT NULL
- order_id — INT — NOT NULL
- quantity — INT
- INDEX — (`menu_id`)
- INDEX — (`order_id`)
orders
- id — INT — Primary key — NOT NULL
- group_order_id — INT — NOT NULL
- user_id — INT — NOT NULL
- restaurant_id — INT — NOT NULL
- price — INT
- reg_date — DATETIME
- INDEX — (`group_order_id`)
- INDEX — (`user_id`)
- INDEX — (`restaurant_id`)
payment
- id — INT — Primary key — NOT NULL
- order_id — INT — NOT NULL
- user_id — INT — NOT NULL
- price — INT — NOT NULL
- reg_date — DATETIME
- INDEX — (`order_id`)
- INDEX — (`user_id`)
pick_up_zone
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
point_history
- id — INT — Primary key — NOT NULL
- shinhan_point_id — INT — NOT NULL
- payment_id — INT — NOT NULL
- account_id — INT — NOT NULL
- before_point — INT
- amount — INT
- change_type — VARCHAR(50)
- created_at — DATETIME
- INDEX — (`shinhan_point_id`)
- INDEX — (`payment_id`)
- INDEX — (`account_id`)
restaurant
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
- address — VARCHAR(255)
shinhan_point
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- point — INT — NOT NULL
user
- id — INT — Primary key — NOT NULL
- student_id — INT
- name — VARCHAR(100) — NOT NULL
- major — VARCHAR(50)