ASSIGNMENT_DB

테이블 (5)

상품 (product)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK1) — BIGINT — 외래 키 → 유저.id — NOT NULL
  • product_category_id (FK2) — BIGINT — 외래 키 → 상품_카테고리.id — NOT NULL
  • product_name (Field) — VARCHAR
  • description (Field2) — TEXT
  • cost (Field3) — BIGINT
  • capactity (Field4) — INT
  • reserved_cnt (Field5) — INT
  • start_date (Field6) — LOCALDATETIME
  • end_date (Field7) — LOCALDATETIME
  • product_state (Field8) — VARCHAR
  • is_deleted (Field9) — TINYINT
  • created_at (Field10) — LOCALDATETIME
  • updated_at (Field11) — LOCALDATETIME

상품_아웃박스 (product_outbox)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • event_type (Field) — VARCHAR
  • event_value (Field2) — TEXT
  • published_count (Field3) — INT
  • is_deleted (Field4) — TINYINT
  • created_at (Field5) — LOCALDATETIME
  • updated_at (Field6) — LOCALDATETIME

상품_카테고리 (product_category)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • parend_it (Field) — BIGINT
  • level (Field2) — BIGINT
  • category (Field3) — VARCHAR
  • is_deleted (Field4) — TINYINT
  • created_at (Field5) — LOCALDATETIME
  • updated_at (Field6) — LOCALDATETIME

수강등록리스트 (enrollment_list)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK1) — BIGINT — 외래 키 → 유저.id — NOT NULL
  • product_id (FK2) — BIGINT — 외래 키 → 상품.id — NOT NULL
  • attendance_state (Field) — VARCHAR
  • is_deleted (Field2) — TINYINT
  • created_at (Field3) — LOCALDATETIME
  • updated_at (Field4) — LOCALDATETIME

유저 (user)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • username (Field) — VARCHAR
  • password (Field2) — VARCHAR
  • email (Field3) — VARCHAR
  • role (Field4) — VARCHAR
  • is_deleted (Field5) — TINYINT
  • created_at (Field6) — LOCALDATETIME
  • updated_at (Field7) — LOCALDATETIME