test
Tables (5)
code
- code_id — BIGINT — Primary key — NOT NULL
- group_code — CHAR(3) — NOT NULL
- code — CHAR(3) — NOT NULL
- code_name — VARCHAR(50) — NOT NULL
- use_yn — CHAR(1)
group_code
- group_code — CHAR(3) — Primary key — NOT NULL
- group_code_name — VARCHAR(50) — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- role — ENUM('admin','user')
- created_at — DATETIME
orders
- order_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- phone_id — BIGINT — NOT NULL
- order_date — DATETIME
- quantity — INT — NOT NULL
- order_regular_price — INT — NOT NULL
- order_discount_amount — INT — NOT NULL
phone
- phone_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- code_id — BIGINT — NOT NULL
- regular_price — INT — NOT NULL
- discount_amount — INT — NOT NULL
- stock — INT — NOT NULL
- is_deleted — TINYINT(1)
- created_at — DATETIME