프로토타인-이동훈

테이블 (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

러브콜? (Untitled9)