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 (잠금을 설정한 사람)