kakaopay_coffee
Tables (5)
TB_MENU
- id — BIGINT — Primary key — NOT NULL
- menu_code — BIGINT
- name — VARCHAR(30)
- inventory — INTEGER
- price — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
TB_ORDER
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → TB_USER.id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
TB_ORDER_MENU (TB_MENU_ORDER)
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → TB_ORDER.id — NOT NULL
- user_id — BIGINT — Foreign key → TB_ORDER.user_id — NOT NULL
- menu_id — BIGINT — Foreign key → TB_MENU.id — NOT NULL
- menu_code — BIGINT
- order_sequence — INTEGER
- quantity — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
TB_USER
- id — BIGINT — Primary key — NOT NULL
- phone — VARCHAR(20)
- name — VARCHAR(30)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- point — INTEGER
TB_USER_POINT_HISTORY
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → TB_USER.id — NOT NULL
- point — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP