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