PROJECT

Tables (4)

IDEA

  • seq (Key) — INT — Primary key — NOT NULL
  • project_name (Field) — VARCHAR(20)
  • short_description (Field2) — VARCHAR(50)
  • purchase_status (Field3) — NUMBER
  • thumbnail_image (Field4) — VARCHAR(100)
  • category (Field5) — VARCHAR(20)
  • motivation (Field6) — VARCHAR(1000)
  • need (Field7) — VARCHAR(1000)
  • strategy (Field8) — VARCHAR(1000)
  • market_analysis (Field9) — VARCHAR(1000)
  • competitivenes (Field10) — VARCHAR(1000)
  • open_level (Field11) — NUMBER
  • id (Key2) — VARHCAR(20) — Foreign key → USERS.id — NOT NULL

LIKEY

  • user_id (Key) — VARHCAR(20) — Foreign key → USERS.id — NOT NULL
  • seq (Key2) — INT — Foreign key → IDEA.seq — NOT NULL

PURCHASE

  • user_id (Key) — VARHCAR(20) — Foreign key → USERS.id — NOT NULL
  • seq (Key2) — INT — Foreign key → IDEA.seq — NOT NULL
  • purchase_level (Field) — INT

USERS

  • id (Key) — VARHCAR(20) — Primary key — NOT NULL
  • password (Field) — VARCHAR(20)
  • name (Field2) — VARCHAR(20)
  • age (Field3) — INT
  • phone (Field4) — VARCHAR(30)
  • address (Field5) — VARCHAR(50)
  • email (Field6) — VARCHAR(30)