1

Tables (8)

cart

  • cart_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • reg_time — DATETIME(6)
  • update_time — DATETIME(6)
  • created_by — VARCHAR(255)
  • modified_by — VARCHAR(255)
  • member_id (member_id2) — BIGINT — Foreign key → member.member_id — NOT NULL

cart_item

  • cart_item_id — BIGINT — Primary key — NOT NULL
  • count — INT — NOT NULL
  • cart_id — BIGINT — Foreign key → cart.cart_id
  • item_id — BIGINT — Foreign key → item.item_id
  • reg_time — DATETIME(6)
  • update_time — DATETIME(6)
  • created_by — VARCHAR(255)
  • modified_by — VARCHAR(255)
  • INDEX — `FK1uobyhgl1wvgt1jpccia8xxs3`
  • INDEX — `FKdljf497fwm1f8eb1h8t6n50u9`

item

  • item_id — BIGINT — Primary key — NOT NULL
  • price — INT — NOT NULL
  • stock_number — INT — NOT NULL
  • reg_time — DATETIME(6)
  • update_time — DATETIME(6)
  • item_nm — VARCHAR(50) — NOT NULL
  • item_sell_status — ENUM('SELL', 'SOLD_OUT')
  • item_detail — TINYTEXT — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • address — VARCHAR(255)
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • password — VARCHAR(255)
  • role — ENUM('ADMIN', 'USER')
  • reg_time — DATETIME(6)
  • update_time — DATETIME(6)
  • created_by — VARCHAR(255)
  • modified_by — VARCHAR(255)

member_item

  • item_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • member_id — BIGINT — Foreign key → item.item_id — NOT NULL
  • INDEX — `FKi40mw84oey77jn8rrgug1lpii`
  • INDEX — `FKnqigcxnpt4inuo1ogt2c2fcgx`

order_item

  • order_item_id — BIGINT — Primary key — NOT NULL
  • count — INT — NOT NULL
  • order_price — INT — NOT NULL
  • item_id — BIGINT — Foreign key → item.item_id
  • order_id — BIGINT — Foreign key → orders.order_id
  • reg_time — DATETIME(6)
  • update_time — DATETIME(6)
  • created_by — VARCHAR(255)
  • modified_by — VARCHAR(255)
  • INDEX — `FKija6hjjiit8dprnmvtvgdp6ru`
  • INDEX — `FKt4dc2r9nbvbujrljv3e23iibt`

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • order_date — DATETIME(6)
  • reg_time — DATETIME(6)
  • update_time — DATETIME(6)
  • created_by — VARCHAR(255)
  • modified_by — VARCHAR(255)
  • order_status — ENUM('CANCEL', 'ORDER')
  • INDEX — `FKpktxwhj3x9m4gth5ff6bkqgeb`

orders_seq

  • next_val — BIGINT