buy-now
Tables (4)
item (CopyOfmember)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(60)
- price (Field4) — BIGINT
- sale_price (Field5) — BIGINT
- stock (Field) — INT
- start_date (Field2) — DATETIME
- end_date (Field3) — DATETIME
member
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(45)
- password — VARCHAR(45)
- name — VARCHAR(45)
- telephone_number (Field4) — VARCHAR(45)
- address (Field5) — VARCHAR(60)
- address_detail (Field) — VARCHAR(60)
- join_date (Field2) — DATETIME
- last_updated_date (Field3) — DATETIME
- admin_yn (Field6) — TINYINT(1)
order_item (CopyOfCopyOfmember)
- order_id (Key) — BIGINT — Foreign key → orders.id — NOT NULL
- item_id (id) — BIGINT — Foreign key → item.id — NOT NULL
- quantity (Field) — INT
- price (Field4) — BIGINT
orders (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (id) — BIGINT — Foreign key → member.id — NOT NULL
- order_no (Field2) — VARCHAR(45)
- name (Field3) — VARCHAR(45)
- telephone_number (Field4) — VARCHAR(45)
- address (Field5) — VARCHAR(60)
- address_detail (Field6) — VARCHAR(60)
- order_date (Field7) — DATETIME
- status (Field8) — VARCHAR(10)
- cancel_date (Field9) — DATETIME