gg
Tables (4)
menus
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — BIGINT — NOT NULL
- order_count — BIGINT — NOT NULL
- created_at — DATETIME(6)
- modified_at — DATETIME(6)
- INDEX — idx_menu_name
orders
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- menu_id — BIGINT — NOT NULL
- total_price — BIGINT — NOT NULL
- created_at — DATETIME(6)
- modified_at — DATETIME(6)
payments
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- imp_uid — VARCHAR(255) — NOT NULL
- amount — BIGINT — NOT NULL
- status — ENUM('READY', 'PAID', 'FAILED', 'CANCELLED') — NOT NULL
- created_at — DATETIME(6)
- modified_at — DATETIME(6)
users
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- point — BIGINT — NOT NULL
- created_at — DATETIME(6)
- modified_at — DATETIME(6)