SAMPLE

Tables (6)

Member (가입자)

  • member_id (PK) — Primary key — NOT NULL
  • team_id (팀 PK) — Foreign key → Team.team_id — NOT NULL
  • name (가입자 이름)
  • age (나이)
  • created_at (가입일시)

Team (팀)

  • team_id (PK) — Primary key — NOT NULL
  • name (팀 이름)
  • logo_image_url (로고 이미지 URL) — NOT NULL
  • created_at (생성일시) — NOT NULL
  • updated_at (수정일시)

interest_asset (관심자산)

  • interest_asset_id (PK) — bigint — Primary key — NOT NULL
  • account_id (Field) — bigint
  • assets (Field2) — varchar2
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

ipo (공모주 메타데이터)

  • id (PK) — bigint — Primary key — NOT NULL
  • stock_name (공모주 이름) — varchar(255)
  • equal_assignment_expected_count (균등배정 예정수량) — bigint
  • proportional_assignment_expected_count (비례배정 예정수량) — bigint
  • assignment_date (배정일자) — timestamp
  • state (상태) — varchar(64)
  • ... — ...

ipo_assignment (공모주 배정내역)

  • id (PK) — bigint — Primary key — NOT NULL
  • ipo_id (FK) — bigint — Foreign key → ipo.id — NOT NULL
  • user_id (사용자 PK) — bigint
  • application_quantity (신청수량) — bigint
  • ipo_margin_amount (청약 증거금) — bigint
  • equal_assignment_count (균등배정 수량) — bigint
  • proportional_assignment_count (비례배정 수량) — bigint
  • total_assignment_count (총 배정 수량) — bigint
  • payment_expected_amount (결제 예정금액) — bigint
  • is_payment (결제완료여부) — bigint
  • ... — ...

my_lock (잠금)

  • lock_id (PK) — Primary key — NOT NULL
  • name (잠금 키 이름(Unique))
  • is_locked (잠금여부)
  • expired_at (잠금 만료시각)
  • locked_at (잠금이 처리된 시각)
  • locked_by (잠금을 설정한 사람)