프로토타인-이동훈
테이블 (10)
Alarm (Untitled2)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- user_id (Key2) — long — 외래 키 → User.id — NOT NULL — autoincrement
- product_id (Key3) — long — 외래 키 → Product.id — NOT NULL — autoincrement
Corporation (Untitled6)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- name (Field) — varchar(30) — NOT NULL — 2글자 이상
- desc (Field2) — text
- created_at (Field3) — datetime — NOT NULL — baseentity
- updated_at (Field4) — datetime — NOT NULL — baseentity
Feedback (Untitled5)
- investment_id (Key) — long — 외래 키 → Investment.id — NOT NULL — autoincrement
- comment (Field) — text — NOT NULL
- rate (Field2) — int — NOT NULL — 0~5
- repurchase (Field3) — bool — NOT NULL
- created_at (Field4) — datetime — NOT NULL — baseentity
- updated_at (Field5) — datetime — NOT NULL — baseentity
Investment (Untitled4)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- user_id (Key3) — long — 외래 키 → User.id — NOT NULL — autoincrement
- product_id (Key2) — long — 외래 키 → Product.id — NOT NULL — autoincrement
- status (Field) — varchar(20) — NOT NULL — enum
- created_at (Field2) — datetime — NOT NULL — baseentity
- updated_at (Field3) — datetime — NOT NULL — baseentity
Like (Untitled)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- user_id (Key2) — long — 외래 키 → User.id — NOT NULL — autoincrement
- product_id (Key3) — long — 외래 키 → Product.id — NOT NULL — autoincrement
Product (Untitled3)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- coperation_id (Key2) — long — 외래 키 → Corporation.id — NOT NULL — autoincrement
- category_id (Key3) — long — 외래 키 → Product_category.id — NOT NULL — autoincrement
- pool_id (Key4) — long — 외래 키 → 고객 풀 설정?.id — NOT NULL — autoincrement
- name (Field) — varchar(30) — NOT NULL — 2글자 이상
- status (Field3) — varchar(20) — NOT NULL — enum
- startdate (Field4) — datetime — NOT NULL
- enddate (Field5) — datetime — NOT NULL
- created_at (Field6) — datetime — NOT NULL — baseentitiy
- updated_at (Field7) — datetime — NOT NULL — baseentitiy
Product_category (Untitled7)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- name (Field) — varchar(20) — NOT NULL
- updated_at (Field2) — datetime — NOT NULL — baseentity
- created_atd (Field3) — datetime — NOT NULL — baseentity
User
- id (Key) — long — 기본 키 — NOT NULL — autoincrement
- name (Field) — varchar(10) — NOT NULL — 2글자 이상
- age (Field2) — int — NOT NULL
- phone_num (Field6) — varchar(15) — NOT NULL
- ticket (Field3) — int — NOT NULL
- created_at (Field4) — datetime — NOT NULL — baseentity
- updated_at (Field5) — datetime — NOT NULL — baseentity
고객 풀 설정? (Untitled8)
- id (Key) — long — 기본 키 — NOT NULL — autoincrement